Question:-
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.
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 do make changes in these assignment otherwise every one who copy this assignment as it is will awarded zero marks
NOTE: - These Assignments OR Quiz are just for idea, so kindly don't copy it, after viewing it make your own. Thanks We always try our best to upload 100% correct solution BUT it is requested that you kindly review it before submission, please BEST OF LUCK, Thanks to those students those send me Assignments and quizzes. If you have any Assignment and quiz kindly send at fascobuk@gmail.com 
No comments:
Post a Comment