Post reply

Slow Query Performance (View)

  • June 23, 2010 at 2:59 am

    #1183794

    Some notes:

    Make sure you have a unique clustered index on IPLocationDB_Location(location)

    Make sure you have a unique nonclustered index on IPLocationDB_Region(CountryCode, RegionCode) INCLUDE(RegionName)

    You should be able to remove the DISTINCT from the query. It is costing you performance and it should not be necessary.

Viewing post 31 (of 30 total)

You must be logged in to reply to this topic. Login to reply