When data is manipulated, the indexes have to be updated. This slows down data manipulation.View more random threads:
- cs302 solved final term papers and quiz by vuhelp fall 2010...
- ECO401 Economics part 2 mid term paper 2011
- Solved ENG301 Business Communication Final Term Paper Fall...
- Solved Paper MTH302 Business Mathematics & Statistics...
- Mkt50marketingmanagement1 midterm solved papers fall 2010
- eco401 mid term solve paper 2011 virtual university of...
- SOC101 Introduction to Sociology mid term solve papas...
- MKT501 Five new midterm papers added
- It430 solved paper of fall 2010 on 19-02-2011 from...
- STA 630 mid term solve papers spring 2011
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.
Sponsored Links
please find the attachment for more questions and answers
Urgent call: 03455242488. | Virtual University Assignments
Virtual University GDBs | Virtual University Papers | Vu Projects | Vu Handouts
About Expert
There are currently 1 users browsing this thread. (0 members and 1 guests)