When data is manipulated, the indexes have to be updated. This slows down data manipulation.View more random threads:
- needs midterm papers
- CS301 Data Structures MIDTERM solve papers Spring 2011
- IT430- E-Commerce MIDTERM EXAMINATION Spring 2011
- STA301 Statistics and Probability MIDTERM EXAMINATION ...
- cs614 solved midterm paper fall 2010 december 5
- Cs101 Intro to programing Solved Midterm Papers fall 2010
- cs614 mid term solve paper april 2011
- REQUIRE SOLVE PAST PAPER OF MGT503(Principles of Management...
- Solved Paper MGT101 Fall 2009 Final Term
- cs101 introduction to computing solved papers fall 2010
Sponsored Links
Answer:-
Search engine indexing collects, parses, and stores data to facilitate fast and accurate information retrieval. Index design incorporates interdisciplinary concepts from linguistics, cognitive psychology, mathematics, informatics, physics, and computer science. An alternate name for the process in the context of search engines designed to
find web pages on the Internet is Web indexing. So doing all this operation indexes have to be updated which causes slow manipulation. Because this operation causes the index to be modified and requires additional updating of each index on that table, SQ L has to internally maintain the “pointers” to the inserted rows in the actual data file, each index potentially adds an alternative access path for a query for the optimizer to consider, which increases the compilation time.
please find the attachment for more questions and answers