What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / swapna vamsi
Indexs are used for the faster retrivel of data.
two types of indexes
Cluster index,unclustered index
we can have one cluster index and uotp 249 cluster indexes
for a table
| Is This Answer Correct ? | 63 Yes | 38 No |
Post New Answer View All Answers
what is the different between now() and current_date()? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is count * in sql?
What is thread join () in threading?
What is sqlca in powerbuilder?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is rowtype?
what is msql? : Sql dba
What is a primary key example?
What is mdf ldf and ndf?
What is the least restrictive isolation level? : Transact sql
What is sql select statement?
What is normalization sql?
What do you mean by dbms? What are its different types?
What are sql data types?