×

Notice

The forum is in read only mode.

What is the purpose of index in SQL Server MCQ?

More
3 months 2 days ago #3338 by Elias Katsaniotis,MSc
What is the purpose of index in SQL Server MCQ?
More
3 months 2 days ago - 3 months 2 days ago #3339 by Elias Katsaniotis,MSc
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: 3 months 2 days ago by Elias Katsaniotis,MSc.
Time to create page: 0.064 seconds

Site Info

V. Katsanioti,

Russia,

Kaliningrad Oblast.

matizegr@yahoo.com

Visit counter

United States of America (the) 80.6% United States of America (the)
Russian Federation (the) 11.1% Russian Federation (the)
China 4.9% China

Total:

33

Countries
00001846
Today: 16
Yesterday: 55
This Week: 71
Last Week: 565
This Month: 1,766
Last Month: 81

Who's Online

We have 1414 guests and no members online