Hi,

I have a column Country and City. On anyone one of the column i should create a index to improve the performance of the query.
Which column should i choose for optimum perf.

Your suggestion is highly appreciated.

Thanks,
Chandra

__________________
Thanks,
Chandra

The usual answer to almost all programming questions: "It depends."

It depends ENTIRELY on the usage pattern of that DB. Nobody can answer the question without that information. What queries do you make on that table that have WHERE clauses that depend on those columns? How often are EACH of those queries used? Those aren't the only questions to ask, but they are a start.