Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
- 3 Answers
- 11604 Views
- TCS, I also Faced
- E-Mail Answers
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 are the parameter modes supported by pl/sql?
how to rename an existing column in a table? : Sql dba
What are the differences between in and exists clause?
What is pl sql quora?
Which is faster union or join?
what is the difference between join and union? : Sql dba
Can we write dml inside a function in sql server?
What is rownum in sql?
What is the difference between rename and alias?
What is aggregate function in sql?
What is nvarchar max in sql?
What are types of exception?
what is the difference between truncate and delete statement? : Transact sql
What is audit logout in sql profiler?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
