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 is package in pl sql with an examples?
Is id a reserved word in sql?
What are all the different types of indexes?
What is structural independence and why is it important?
what is meant by urlencode and urldocode? : Sql dba
who introduced sql?
What does an inner join do?
What is t sql used for?
What is minus?
What is the difference between function, procedure and package in pl/sql?
How many types of sql are there?
What is the location of pre_defined_functions.
How do I tune a sql query?
Define a temp table?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba