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 a user role in oracle?
what is the syntax of SELECT command?
What is the best way to do multi-row insert in oracle?
Whether any commands are used for months calculation? If so, what are they?
How to view the tablespaces in the current database?
How to join two tables in a single query using oracle?
How to create a new table by selecting rows from another table?
what is integrity constrains?
Explain how are indexes update?
What privilege is needed for a user to delete rows from tables in another schema?
find the second highest salary of the emp table
How would you design a database for an e-commerce website?