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 types of dbms?
How to create a menu in sqlplus or pl/sql?
what are all types of user defined functions? : Sql dba
What does (*) mean in sql?
How to create your own reports in sql developer?
How to pronounce postgresql?
What is sql basics?
Why is pl sql used?
What does the hierarchical profiler does?
Does inner join return duplicate rows?
Is keyword pl sql?
What are the topics in pl sql?
How to look at the current sql*plus system settings?
How do you truncate?
Which is faster view or stored procedure?