What is an Index?

Answer Posted / uma

index is used to speed up query execution,indices are used
to locate the tables in the database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is partition in sql server?

534


Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

596


how can u get last observation in an unknown dataset ?

2003


How to test odbc dsn connection settings?

536


How many levels of sp nesting are possible?

557






What is the difference between primary key and unique constraints?

516


What to perform pattern match with the like operator?

487


what is the difference between Tabular and Matrix report?

124


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

548


Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

518


Explain having clause and where clause?

585


Explain triggers in sql?

558


How to select some specific rows from a table in ms sql server?

574


Is it safe to delete log files?

527


What is difference between views and tables?

470