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
What is clause in sql?
Is sql procedural language?
Does a join table need a primary key?
How many row comparison operators are used while working with a subquery?
What is the difference between instead of trigger and after trigger?
how to get a list of all tables in a database? : Sql dba
How can we debug in PL/SQL?
What is prepared statement in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What are the types of keys?
What is function and procedure in pl sql?
What is procedure function?
What is cartesian join in sql?
In a distributed database system, can we execute two queries simultaneously?
What are user defined functions?