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 is 'write-ahead log' in sql server 2000 ?
What is xdr?
what is a traditional network library for sql servers? : Sql server database administration
What are cascading parameters in ssrs reports?
Explain the steps to use transact-sql cursor?
Why normalization is used?
Explain candidate key, alternate key, and composite key?
Explain what is dbcc?
Mention the uses of stored procedures.
What is the use of “join” in sql server?
What to check if a User database is locked?
How to write a query with a right outer join in ms sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How can I create a report based on a query? : sql server management studio
Do you know how to store and query spatial data?