What is an index and types of indexes. How many number of
indexes can be used per table ?

Answer Posted / sandip kumar chaturvedi

index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.

Is This Answer Correct ?    20 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of set statement in tsql? : Transact sql

740


Can we use insert statement in function?

735


What is union?

815


How long will it take to learn pl sql?

689


Are sql database names case sensitive?

687






Is not null in sql?

732


What is database migration?

696


How to Execute a Package in PL/SQL.?

807


Can a foreign key be a duplicate?

682


What is the difference between nested table and varray?

688


What is %rowtype in pl sql?

693


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1079


What is a temporal table?

666


What do you think about pl/sql?

701


What is a subquery in sql?

694