About this question
I dug couple of hours regarding my question and didn't get satisfactory answer. Still I have doubt. I have found the following about Clustered Index: Data is stored in the order of the clustered index. Only one clustered index per table. When a primary key is created a clustered index is automatically created as well.
I got these points, but my questions are: Does Clustered index exist in Oracle database? since I read in some blogs "Oracle does not have a concept of a clustered index." If yes, please let me know the sql statement to create a clustered index. As said above, clustered index automatically gets created when primary key is defined on a column of a table, how can I check the index type if it is created or not ?
Please find my table architecture :
Let me know if anything else is required to get answers for these questions.