What is Index Cluster ?
Answers were Sorted based on User's Feedback
Answer / swapna
we can create Index on clusters.
syntax: create index<i_name> on cluster(cluster_name);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to Identify the previously inserted/updated records in already populated table.
What is an anonymous block?
Is it possible to enter only time value into a column of a table in sql?
Explain view?
Can a field be used in a report without it appearing in any data group ?
What is the difference between postgresql and oracle?
How to use "in" parameter properly?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What are the composite date types in oracle?
Explain the use of tables option in exp command.
How to write numeric literals in oracle?