What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / diptabhaskar ray
the ordering of a table in a database is called index.it
helps in fast access to the specific information.the column
suitable for index should be a primary key or a foreign
key,should be sorted,joins should be allowed and users will
search for data.clustered index and non clustered index.
| Is This Answer Correct ? | 20 Yes | 17 No |
Post New Answer View All Answers
What are the built in functions of sql?
What is difference between stored procedure and trigger?
What is a table?
What does select top 1 do in sql?
What is the unique index?
What is trigger types of trigger?
What is sql partition function?
What are the two characteristics of a primary key?
What are the types of queries in sql?
what are the differences between char and nchar? : Sql dba
what are tables and fields? : Sql dba
How do I restart sql?
Is pl sql different from sql?
What is informix sql?
What is the starting oracle error number? What is meant by forward declaration in functions?