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
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How to start and end transact-sql statements?
Where views are stored in sql server?
What is the report model project?
What is right outer join in sql server joins?
What are types of scd? : sql server analysis services, ssas
What is trigger in salesforce?
How can I know what locks are running on which resource?
Differentiate between ms sql server reporting services vs crystal reports?
How to define the name and server for a new dsn?
Explain what are the authentication modes in sql server?
Does union all remove duplicates?
When cursors are useful?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is the difference function and stored procedure?