1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between cluster and non cluster index? : Sql dba

Question Posted / rohit arora


what is the difference between cluster and non cluster index? : Sql dba..

Answer / Jitendra Kumar Srivastava

A cluster index, also known as a clustered index, reorders the data physically in the database according to the index key. A non-cluster index organizes the data independently of the physical order in the database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the use of time stamp in select statement?

1 Answers   TCS,

What are character functions?

1 Answers  

How is use pl and sql?

1 Answers  

what is error ora-03113: end-of-file on communication channel?

1 Answers  

What is record type in pl sql?

1 Answers  

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

What is scalar function?

1 Answers  

how can i read write files from pl/sql

3 Answers  

What are sql queries used for?

1 Answers  

What is sql clause?

1 Answers  

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories