Avatar of PHIL Sawyer
PHIL Sawyer
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Adding Indexes

I have one table that I run a query on - it currently has around 30 million rows and growing daily by around 300,000 rows. The table has one Clustered index on the date field.
In my reporting tool which interrogates this table I have 4 filters - primarily in the following order.
Date (hence Clustered index on date)

Could I improve performance by adding indexes for Country, Region and Gender - or is the Clutsered date index sufficient?

Microsoft SQL Server

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon