index is used to speed up query execution,indices are used to locate the

What is an Index?

Question Posted / uma

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

Please Help Members By Posting Answers For Below Questions

What are the differences between clustered and non-clustered index?

1033

Define Business Edition in SQL Azure?

100

What is the purpose of self join?

975

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1012

Difference between primary key and clustered index?

1013

How to insert data into an existing table?

981

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

988

What are the differences between triggers and stored procedures?

1070

How to connect php with different port numbers?

1088

What is the difference between clustered and a non-clustered index?

1031

What is scan table/view and seek table/view when its occurs? : sql server database administration

1057

Explain SSRS Architecture?

196

What is difference between Datepart() and Datename() in SqlServer?

1210

Which are the new data types introduced in sql server 2008?

883