01-29-2011, 11:02 PM
When data is manipulated, the indexes have to be updated. This slows down data manipulation.
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
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