What is an Index?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SubQuery in SQL Server 2008

556


Define msdb database?

600


What is the difference between cartesian product and cross join?

482


What is the difference between having clause and where clause in sql server?

575


How to send a ssrs report from ssis?

125






What are the properties and different types of sub-queries?

568


wat wil hapn if we give the both read and deny read permission to user?

1658


What is a primary key?

543


explain different types of constraints? : Sql server database administration

518


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1549


Explain having clause?

530


How to loop through returning rows?

577


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2087


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

593


What is the difference between index seek vs. Index scan?

580