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
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How ssrs maintain security?
Explain linked server in sql?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the stuff?
What is mean by dml?
What is the fastest way to permanently delete a 1 million row table named customers?
What are the disadvantages of indexes?
What is ms sql server index?
What is a bit datatype?
Explain the truncate command? : SQL Server Architecture
What is the importance of concurrency control?
What it means to be triggered?
What is field with example?
What is the current pricing model of SQL Azure?