35,10,0,50,1
25,600,60,0,3000,5000,25,800
90,150,1,50,12,30,50,1,70,12,1,50,1,1,1,5000
0,2,1,0,2,40,15,5,2,1,0,20,0,1
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com...
welcome to wplecturer.com...
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com

What is the purpose of index in SQL Server MCQ?

More
1 month 2 days ago #3338 by ekatsa
What is the purpose of index in SQL Server MCQ?

Please Log in to join the conversation.

More
1 month 2 days ago - 1 month 2 days ago #3339 by ekatsa
Answered by ekatsa on question What is the purpose of index in SQL Server MCQ?
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.
Last edit: 1 month 2 days ago by ekatsa.

Please Log in to join the conversation.

Time to create page: 0.248 seconds