What is Index Cluster ?

Answer Posted / nishi

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does the on-delete-cascade statement work?

619


How to open a cursor variable?

620


What is Trigger in Oracle?

584


What is not equal to in oracle?

542


What is merge statement used for?

580






Is the After report trigger fired if the report execution fails ?

2415


What is user managed backup in Oracle?

622


How to put more than 1000 values into an oracle in clause?

596


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2899


What is the difference between truncate & delete command?

630


Explain what does a control file contain?

619


What is the difference between primary key and unique key and foreign key in oracle?

560


Explain the different normalization forms?

603


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1812


Is java required for oracle client?

556