- Posts: 4306
- Thank you received: 0
What is the purpose of index in SQL Server MCQ? |
- Elias
Topic Author- Offline
- Administrator
Less More
- Elias
- Topic Author
- Offline
- Administrator
Less More
- Posts: 4306
- Thank you received: 0
6 months 6 days ago - 6 months 6 days ago#3339by Elias
A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes. (google)
This is not all. From Oracle I know that if you want a full table scan or above 70% the index delay the retrieval.
If less is ok.In general we use index to find the proper record(s) that must manage (update,delete,view), and in many cases this become faster with index.
This is not all. From Oracle I know that if you want a full table scan or above 70% the index delay the retrieval.
If less is ok.In general we use index to find the proper record(s) that must manage (update,delete,view), and in many cases this become faster with index.
Last edit: 6 months 6 days ago by Elias.
Time to create page: 0.073 seconds
Contact
Site Info
V. Katsanioti,
Russia,
Kaliningrad Oblast.
matizegr@yahoo.com
Who's Online
We have 92 guests and no members online