When data is manipulated, the indexes have to be updated. This slows down data manipulation.View more random threads:
- MGT613 Production / Operations Management solve paper april...
- mgt411 money and banking fall 2010 Solved papers
- mgt411 solved midterm paper fall 2010 december 3
- MGT502 Midterm Papers fall 2009
- It430 solved paper of fall 2010 on 19-02-2011 from...
- ENG201 Business and Technical English Writing Midterm...
- Solved ECO401 Economics Final Term Paper Fall 2009
- mkt501 solved mcqs for midterm and solved midterm past...
- MGT501 Human Resource Management solve mid term paper 2011
- mgt503 mid term solve paper 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.
please find the attachment for more questions and answers
Sponsored Links
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)