What is an Index?

Question Posted / guest

3 Answers
9664 Views
Yardi Software, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is an Index?..

Answer / srinivas

Index is a database object which improves the efficiency of
the query

Is This Answer Correct ?

6 Yes

0 No

What is an Index?..

Answer / guest

When queries are run against a db, an index on that db
basically helps in the way the data is sorted to process the
query for faster and data retrievals are much faster when we
have an index.

Is This Answer Correct ?

1 Yes

0 No

What is an Index?..

Answer / 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

More SQL Server Interview Questions

what happens on checkpoint? : Sql server database administration

0 Answers

Explain syntax for viewing, dropping and disabling triggers?

0 Answers

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers

What is truncate table?

0 Answers

What do you understand by mirroring?

0 Answers

Can we create nonclustered index in a table without creating a clustered index

1 Answers

What is the difference between update lock and exclusive lock?

0 Answers

Explain “@@rowcount” and “@@error” in sql server?

0 Answers

What is difference between standardization and normalization?