How does non-cluster index functions?



How does non-cluster index functions?..

Answer / Nitin Trivedi

A non-cluster index stores the indexed columns and a pointer to the original data. When you search for data using a non-cluster index, it first finds the pointer and then retrieves the actual data from the data file.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

if i want to display the name of students such that to which city they belong must have count greaer than two

1 Answers   Atos Origin,


Its possible to use auto increment in oracle or not? If no means why?

1 Answers  


Which database is best to store images?

1 Answers  


What will happen non-clustered index will be created on clustered index?

1 Answers   Abacus,


What are different types of resources?

1 Answers  


Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

1 Answers  


Can we use redis as database?

1 Answers  


How heap is implemented in database?

1 Answers   Amazon,


How do I setup a database connection?

1 Answers  


What is a database example?

1 Answers  


what is the role of auditor in auditing data oriented applications?

1 Answers  


What is the role of tester in discovery(in Checklist)?

1 Answers  


Categories