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 a mutating table

5 Answers   TCS, Tech Mahindra,

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

What is pl sql script?

0 Answers  

---

Write a sql select query that only returns each name only once from a table?

0 Answers  

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

Can delete statement be rollbacked?

0 Answers  

---

What is the difference between microsoft access and sql server?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

What is lookup table in sql?

0 Answers  

---