Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14037 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / ganesh sial
both index are stored physically but cluster index is create block of key value which more helps to like join,hash condition,more reliable to parent child relation ship
ex:- deptno is primary key for dept table, its create cluster index,
when write query of join like
select a.empno,a.deptno,b.loc from emp a,dept b where a.deptno=b.deptno
this case the cluster index helps to better perfomance
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is data type in sql?
What is crud sql?
How to fetch alternate records from a table?
What packages are available to pl/sql developers?
How to display the current date in sql?
What is a behavioral trigger?
What are all ddl commands?
Can we use joins in subquery?
How do you write an index?
Is coalesce faster than isnull?
What are aggregate functions in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
How to check if a column is nullable before setting to nullable?
What is difference between rank () row_number () and dense_rank () in sql?
Which table is left in left join?
