Click here to Skip to main content
15,905,071 members
Search within:


example of using Non clustered index with quey execution
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
SQL-Server
hi
i am clear about how clustered index works but i am still confuse how non clustered index works.can any one explain me with query and execution process.

Regards
brijesh parikh
Posted
Add a Solution
Comments
ZurdoDev 21-Mar-12 7:50am    
It is also an index so it will work very similar. What exactly is the question?
brijesh d parikh 22-Mar-12 0:12am    
hi. if we have a clustered index we follow binary structure but if non clustered then what method we follow?how it search record comparing non clustered index and non index column.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Cluster index taking 100% cost in SQL
using non clustered and clustered index but no effect on time execution in sql
Cluster and Non Cluster index
Why should we use clustered index and non clustered index
what is the use of non clusters index in a table
Difference between clustered and non clustered index in sql server
Non clustered indexing does not reflect in the query performance
What is indexer and their types when to use cluster index and non cluster index in sql server
Understanding Clustered and Non Clustered Index
Doubt in clustered and non clustered index

Advertise
Privacy
Cookies
Terms of Use
Last Updated 21 Mar 2012
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-05-23:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900