What is an index?

Answer Posted / krishna chaithanya

index allows to search record in a table making the search
meachnism faster and effective

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits and tasks of object explorer? : sql server management studio

611


What are the restrictions that views have to follow?

562


How to create an index on an existing table in ms sql server?

499


What is precedence constraint?

546


what is the difference between a primary key and a unique key? : Sql server database administration

531






Do you know what is xpath?

559


What is transaction server distributed transaction?

561


What is the optimization being performed in oracle and SQL Server?

632


Explain what is lock escalation and what is its purpose?

513


Why do we need different type of parameter?

548


What specific conditions database should meet, before you can bulk copy data into it using bcp?

536


How to execute a stored procedure in ms sql server?

554


How can you control the amount of free space in your index pages?

620


How do I find the sql server version?

527


Explain about SQL server 2005?

563