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
- 11758 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 a pdo connection?
What do you mean by table in sql?
How many sql statements are used? Define them.
Is pl sql a programming language?
How do you delete duplicates in sql query using rowid?
Why join is faster than subquery?
What are local and global Indexes and where they are useful.
What is plpgsql language?
What are the advantages of stored procedure?
Explain some predefined exceptions.
Can we write ddl statements in functions?
Does asenumerable execute the query?
What is the purpose of the primary key?
Is it important to partition hard disk?
How do I view a table in sql?
