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 are data pump export and import modes?
26. Display the earliest shipping date in the format: DD/MON/YYYY
How to omit columns with default values in insert statement in oracle?
How would you optimize a slow SQL query?
What are the limitations oracle database 10g xe?
What is difference between SUBSTR and INSTR?
How to use regular expression in pattern match conditions in oracle?
What are the uses of a database trigger?
What is a trigger oracle?
How do we represent comments in oracle?
what diffrence between function and procedure?
What are the different types of database objects?