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 are local and global variables and their differences? : Sql dba
What is sql prepared statement?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is a left inner join?
What is update query?
Define a temp table?
How do you respond to dementia behavior?
What are the subsets of sql?
How many triggers can be applied on a table?
What are sql functions? Describe in brief different types of sql functions?
Explain the difference in execution of triggers and stored procedures?
What is sql and its types?
How do you update f as m and m as f from the below table testtable?
How delete all data from all tables in sql?
What are the types of optimization?