Answer / thangaprabu.n

Apart From above answer,One table Contain only 1 Cluster
index and 249 Non-Cluster Indexes

Answer / shubhi

There are clustered and nonclustered indexes. A clustered
index is a special type of index that reorders the way
records in the table are physically stored. Therefore table
can have only one clustered index. The leaf nodes of a
clustered index contain the data pages.

A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.

Answer / nive

clustered index are physically sorted

Answer / 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

What is primary key and foreign key?

0 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

how is myisam table stored? : Sql dba

0 Answers  

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

---

what is the difference between sql and t-sql? : Transact sql

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What is the difference between join and natural join?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

How do I pipe the output of one isql to another?

0 Answers  

---

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---