Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes? When do you need to create Indexes?
- 4 Answers
- 8188 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
Does table partitioning improve performance?
What are the underflow and overflow behaviors on float literals?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What will be query used to get the list of triggers in a database?
Do you know what are the properties of the relational tables?
How to modify an existing stored procedure in ms sql server?
What are sql server functions?
What is etl - extraction, transformation, and loading?
Can two tables share a primary key?
Can you leave a union at any time?
What are the types of database recovery models?
Do you know sql server 2008 backup compression?
Can we deploy SSRS reports on our personal website?
what authentication modes does sql server support? : Sql server database administration
What is bit data type?
