What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
Answers were Sorted based on User's Feedback
Answer / rajkumar
please don't give oracle answers in sqlserver
Is This Answer Correct ? | 12 Yes | 8 No |
Answer / leena
clustered index physically store data orderly in a
table,but non-clustered index store data logically not
physically.
primary key is by default clustered index,and unique key is
by default non-clustered index.
A table can contain only one cluster index.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
What is a rank in sql?
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
explain the options of myisamchk to improve the performance of a table. : Sql dba
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000
What do you understand by pl/sql cursors?
What is bulk collect in pl sql?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
What is crud diagram?
How is a PL/SQL code compiled?
Is postgresql a server?
Is keyword pl sql?
how to get the third quarter of employee details from emp?