What is an index?

Answer Posted / sanjay mukati

Index is a such type of mechanism in which records are
searched and fetched efficiently and fastly in a table. It
is physical address of data.

Two type of index :
A. Cluster Index
B. Noncluster Index

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about sql server login?

589


What is the openxml statement in sql server?

536


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

503


what are acid properties? : Sql server database administration

488


What does it mean to normalize a database and why would you do it?

525






What does it mean to normalize data?

512


Write an SQL query to obtain the 2nd highest salary.

604


Which language is supported by sql server?

553


Which tcp/ip port does the sql server run on? How can it be changed?

523


Why I am getting this error when dropping a database in ms sql server?

588


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

495


Mention the differences between substr and charindex in sql server.

515


What are commit and rollback in sql?

563


Why truncate is ddl command?

512


What is a data collection table?

540