CREATE NONCLUSTERED INDEX - > QUESTION

I have one column tha have many values that repeat, and I need use join with
this column, I should create an NONCLUSTERED INDEX to improve performance?
ThanksOne of the great things about non-clustered indexes is that you can
just add them and see how well they work, and drop them if the don't.
No need to guess, find out and know!
Roy
On Thu, 23 Feb 2006 20:41:35 -0300, "ReTF" <re.tf@.newsgroup.nospam>
wrote:

>I have one column tha have many values that repeat, and I need use join wit
h
>this column, I should create an NONCLUSTERED INDEX to improve performance?
>
>Thanks
>|||Hello Roy,
I think Index tuning wizard will be helpful in this situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.