raj.prabhu001 (8/3/2014)
Hello,I have a fact table which has six field now and I have created non clustered index on all fields.
It will also have more fields later with millions of records .
Please suggest me my indexing will help on this table or should I create index in some other way to optimise performance .
Thanks
Can you provide execution plan, query statistics and sample queries?
These are the kinds of things that are required to make tuning suggestions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events