How to Create the correct Index?

Last Post 05 Mar 2008 05:53 AM by dstoltz. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dstoltz
New Member
New Member

--
04 Mar 2008 11:29 AM
Hey All,

I have this query:
SELECT DISTINCT cc_fips FROM cities WHERE subregion = '2B' ORDER BY cc_fips

There are over 2.5 million rows in the cities table....

If I wanted to create an index for this query, how would I do it through EM?

I tried to do it by going to Design Table, Properties, Index Tab, NEW, selecting cc_fips/ascending...

It didn't seem to help much...I did NOT click the "clustered" checkbox, nor did I change the fill from 0% - since I didn't really know what either do...

Can someone offer some advice?

Thanks!


FORGOT TO ASK: Once the Index is added, how does that change my query, if at all?
dstoltz
New Member
New Member

--
05 Mar 2008 05:53 AM
does my query stay the same?
You are not authorized to post a reply.

Acceptable Use Policy