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?
FORGOT TO ASK: Once the Index is added, how does that change my query, if at all?