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
- 11622 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 is nvarchar max in sql?
Is postgresql a server?
How can we link a sql database to an existing android app?
how to get a list of indexes of an existing table? : Sql dba
Explain the order of sql statement execution?
What are the sql commands?
What is difference between sql and oracle?
what does it mean to have quoted_identifier on? : Sql dba
When can we use the where clause and the having clause?
Differentiate between % rowtype and type record.
How to create a menu in sqlplus or pl/sql?
How do I delete a trigger?
What is scalar data type in pl sql?
how to convert character strings to dates? : Sql dba
Why function is used in sql?
