What are indexes? When do you need to create Indexes?
Answer Posted / bhagwat sharma
When data volumes increase, organizations are faced with
problems relating to data retrieval and posting. They feel
the need for a mechanism that will increase the speed of
data access. An index, like the index of a book, enables the
database retrieve and present data to the end user with
ease. An index can be defined as a mechanism for providing
fast access to table rows and for enforcing constraints.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does the update command do?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is the definition for sql server 2000?
What are two difference between sql azure and azure tables?
What is user-defined function?
What are the main differences between #temp tables and @table variables and which one is preferred?
How to find tables without indexes?
Explain the steps to create and execute a user-defined function in the sql server?
What is scalar user-defined function?
How to manipulate data from one table to another table ?
Describe different Processing Modes offered by SSRS?
How many database files are there in sql server 2000?what are they?
What is query parameter in ssrs?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How fixed length strings are truncated and padded?