2.4k questions

2.4k answers

95.4k users

7 Online Users
1 Member 6 Guest
Online Members
Today Visits : 2234
Yesterday Visits : 2079
Total Visits : 2337668

Categories

Notice

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
58 views

What is the purpose of index in SQL Server MCQ?
in General by (95.8k points)
reshown by

1 Answer

0 votes

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 retrival. 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.

by (95.8k points)
...