Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 20, 2013 06:05 PM by ahsan_kabir_shuvo
Apr 10, 2010 05:09 PM|LINK
where should we use clustered index and non clustered index.i mean in day to day use which on e to choice and how to make decision.
please explain in detail with valid points to choice.
Apr 10, 2010 05:30 PM|LINK
use culsture in which you use join
Apr 11, 2010 11:22 AM|LINK
can you give some more explanation, i am not able to understand it(i know the definition ),but i need some hard core real world purpose of using...
Apr 11, 2010 11:40 AM|LINK
lets take example, generally we use table like below
countryid int primary key
EMPID int primarykey
As empid and country id is primary key than default cluster index will automatically apply.
Now our more transaction will occur in empid and countryid then we will remove cluster index from empid and apply to country id to boost of the performance
Similarly if we are using join base on countrycode
than we will remove cluster index from empid and countryid both and will keep on countrycode of both table.
Conclusion is that in which more column are using for join we need to keep cluster index on that to boost of the performance.
Please let me know if require more info.
Mark as answer if it helps.
Apr 11, 2010 12:16 PM|LINK
thanks for your quick Response,
please help me on this,
as you said in order to keep the performance boosting we should use cluster index on columns which are used for joining but in the below mentioned line you are saying remove cluster index from empid and apply to country id. whats point here i am not getting
it(i mean why we should remove cluster index from empid, we can keep for both).
"Now our more transaction will occur in empid and countryid then we will remove cluster index from empid and apply to country id to boost of the performance"
one more Question. If cluster index boost the performance whats use of non cluster index,where should we use it..?
it may look very simple but i am not getting it ,so please clarify me.
Apr 12, 2010 04:19 AM|LINK
any one please share some details regarding cluster and non cluster index and there appropriate use.
Apr 12, 2010 04:54 AM|LINK
please check these links
Apr 12, 2010 04:55 AM|LINK
Please remember to mark the replies as answers if they help
Apr 12, 2010 05:09 AM|LINK
Jan 20, 2013 06:05 PM|LINK
You can say it 's a basic rule of thumb that use no clustered indexes when small amounts of data will be returned and clustered indexes when larger result sets will be returned by your query. On-Clustered index is depends upon the query running against the
table. There is no ideal index structure available. It all depends upon the kind of application you have and query you run. You may also do a live search on Covering Indexes.
Click on below link :