What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / jeevan
Index is nothing but an identification of each row. It will be used for quick search.
Types Of Index:
---------------
Clustered Index:
Clustered index is a physical sorting of database table’s rows in a storage media. For this reason, each table may have one clustered index. If a primary key constraint is created for a table but no clustered index exists for a table, then SQL server automatically create a clustered index on a primary key.
Non Clustered Index:
Non clustered index are created outside of the table and contain a sorted list of references to a table itself. Maximum we can use 249 clustered indexes per table.
Note:
Only 1 clustered Index can be used per table.
Maximum 249 non clustered index can be used per table.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are sql*plus environment variables?
How do I tune a sql query?
Mention what is the plv (pl/vision) package offers?
How to run sql*plus commands in sql developer?
What is a null value?
How to call a javascript function from pl sql?
What are the different types of tables in sql?
What are variables in pl sql?
What are the benefits of pl/sql packages?
How do temporal tables work?
Which is better join or inner query?
how to create a test table in your mysql server? : Sql dba
What does select count (*) mean in sql?
How do I add a primary key to a table?
Differentiate between % rowtype and type record.