What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
Answer Posted / amit
A clustered index are those which created by user manually
and non clustered are automatically created by oracle server
when we create a primary key or a unique key on a column.
and as many as indexes can be created on table but it will
reduces the performance of the database.
Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
what tools available for managing mysql server? : Sql dba
What are keys in sql?
How do I run a script in sql developer?
How to know the last executed procedure?
How many sql core licenses do I need?
What is tuple in sql?
How many aggregate functions are available there in sql?
How many commands are there in sql?
What is difference between inner join and self join?
Why do we use procedures in sql?
Can a foreign key be a duplicate?
What operating systems are supported by oracle sql developer?
What is a column in a table?
Why is sql better than hql?
How do I remove duplicates in two columns?