Home Forums SQL Server 2008 T-SQL (SS2K8) help me to create useful index (while using dynamic query) RE: help me to create useful index (while using dynamic query)

  • February 22, 2013 at 6:01 am

    #1590311

    Mate,

    Thanks for your reply.

    What will you suggest for:

    Question 1: If I am searching for a city(or state) then Should I use

    Country = @country AND StateID = @stateID AND CityID = @cityID

    or only

    CityID = @cityID (for city)

    StateID = @stateID (for state)