Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes? When do you need to create Indexes?
- 4 Answers
- 8421 Views
- CarrizalSoft Technologies, HP, I also Faced
- E-Mail Answers
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
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What does it mean to manipulate data?
What do you understand by triggers and mention the different types of it?
What are locks in sql?
What are system databases into sql server (2005/2008)?
Define magic tables in sql server?
what is unique and xaml nonclustered index
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Explain what is the difference between union and union all?
How can you list all the table constraints in a database?
What is a livelock?
What is raid and what are different types of raid levels?
Where are sql server user names and passwords stored in sql server?
What is a file group?
