What is clustered and non-clustered indexes?
Answers were Sorted based on User's Feedback
Answer / thangaprabu.n
Apart From above answer,One table Contain only 1 Cluster
index and 249 Non-Cluster Indexes
| Is This Answer Correct ? | 9 Yes | 2 No |
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.
| Is This Answer Correct ? | 9 Yes | 3 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
What is primary key and foreign key?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
how is myisam table stored? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
what is the difference between sql and t-sql? : Transact sql
What are the differences between Database Trigger and Integrity constraints ?
I need a function for a train ticket reservation please answer it thanks in advance
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
What is the difference between join and natural join?
how to include comments in sql statements? : Sql dba
How do I pipe the output of one isql to another?
how to analyze tables with 'mysqlcheck'? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)