Interested to Buy Any Domain ? << Click Here >> for more details...
How many index can be created for single table
- 4 Answers
- 18321 Views
- CarrizalSoft Technologies, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sureshsamatham
There can be 1 or more indexes in a table.Indexes can be
clustered or non clustered. A clustered index stores data
rows in the table based on their key values. Each table can
have only one clustered index as the key values in the data
rows are unique and the index is built on the unique key
column. Non-Clustered indexes have structures that are
different from the data rows. A non clustered index key
value is used to point to data rows that contain the key
value. This value is known as row locator. The structure of
the row locator is determined on the basis of the type of
storage of the data pages. If the data page is stored as a
heap, a row locator becomes a pointer to a row. If the data
page is stored in a clustered table the row locator is a
clustered index key. Clustered and Non clustered indexes can
be unique and indexes are automatically maintained for a
table or view whenever the data table is modified.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Do you know query execution plan?
How to move database physical files in ms sql server?
Explain transaction server auto commit?
How can I know what locks are running on which resource?
What is the downside of using udf?
Benefits of Stored Procedures?
what is the difference between delete table and truncate table commands? : Sql server database administration
Define indexes?
What is the impact on other user sessions when creating indexes?
Explain difference between cross join and full outer join?
What is the difference in accessing db between sql server vs sql azure?
What is the difference between ddl,dml and dcl commands?
How to set a database state to offline in ms sql server?
Name and describe few console utilities for ssrs?
What is the standby server?
