What is clustered index in sql?



What is clustered index in sql?..

Answer / Indira.v

A Clustered Index in SQL organizes data physically based on the indexed column(s) in a table. It's a type of index that stores the actual data pages in a specific order, making it more efficient for retrieving data when the query is based on the clustered index.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the types of join and explain each?

1 Answers  


How to start oracle sql developer?

1 Answers  


i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,


Explain the difference between triggers and constraints?

1 Answers  


What is the meaning of disabling a trigger?

1 Answers  


What do you understand by pl/sql cursors?

1 Answers  


How many sql are there?

1 Answers  


write the Sql query for creating database backup?

7 Answers   TCS,


how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,


Is left join inner or outer by default?

1 Answers  


What is dynamic sql in pl sql?

1 Answers  


Why do we use sqlite?

1 Answers  


Categories