Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

How to create Clustered and non clustered index in Oracle?

Asked by Ankesh Kumar Apr 22, 2021 1.9K views 1 answer
Share

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 :

enter image description here

Let me know if anything else is required to get answers for these questions.



Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.