What is clustered and non-clustered indexes?
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 the difference between local variables and global variables?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is dml statement?
Is delete faster than truncate?
What is package in pl sql?
How does an execution block start and end in pl sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the difference between cross join and natural join?
What are the built in functions of sql?
what is sql? : Sql dba
What are the ddl commands?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is constant in pl sql?
Why do we use procedures in sql?
What language is oracle sql developer?