What is an index?

Answer Posted / sovan guha

An index is a physical structure containing pointer to the
data.Index are created in an existing table to locate rows
more efficiently and quickly.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

550


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

545


Does sql server use t sql?

525


What is model database in sql server?

567


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

564






What is @@rowcount in sql?

554


What are the steps to follow to configure SQL*Net?

557


How to get a list all databases on the sql server?

579


What is recompile sql server?

565


How to achieve Paging of records in SQL SERVER?

592


What stored by the msdb? : sql server database administration

556


What is the sql case statement used for?

557


Explain the difference between primary keys and foreign keys?

509


How to insert a new row into a table with "insert into" statements in ms sql server?

533


What are different backups available in sql server?

601