Home » SQL & PL/SQL » SQL & PL/SQL » Difference between Clustered index and non clustered index
Difference between Clustered index and non clustered index [message #237869] Wed, 16 May 2007 01:00 Go to next message
gowthamtnr
Messages: 1
Registered: March 2007
Location: CHE
Junior Member
Hi All,
1.whats the Difference between Clustered index and non clustered index in oracle 9i?

2.what is SAFE Exception? (is there any thing like this? bcas it was asked in interview.)


Re: Difference between Clustered index and non clustered index [message #237876 is a reply to message #237869] Wed, 16 May 2007 01:17 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
gowthamtnr wrote on Wed, 16 May 2007 08:00
(is there any thing like this? bcas it was asked in interview.)

Then I suppose you told the interviewer you didn't know and asked him/her what he meant by it. Then the interviewer told you what he meant and a nice discussion between the two of you started, and you got hired, because you showed him you are interested in things concerning your job and are eager to learn new things...
Re: Difference between Clustered index and non clustered index [message #238161 is a reply to message #237876] Wed, 16 May 2007 22:02 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
A Cluster Index is the index used to access tables stored in an Indexed Cluster (as opposed to bog-standard heap-organised tables). Lookup Clusters in the Concepts manual.

The interviewer was much more likely to have been talking about the Clustering Factor of an Index, which is a measure of the degree to which adjacent rows in the index can be found in the same block in the table. Search on Clustering Factor.

Ross Leishman
Re: Difference between Clustered index and non clustered index [message #238181 is a reply to message #238161] Thu, 17 May 2007 00:43 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I thought he might be referring to a SAVE EXCEPTIONS clause of bulk operations.

MHE
Previous Topic: Some interview questions.
Next Topic: Conditional Compilation in PLSQL
Goto Forum:
  


Current Time: Thu Dec 26 17:29:16 CST 2024