Originally posted by Sameer
BUT It will definately improve the speed of retrival of data if you specify the sequence of the columns in the WHERE condition as you specified in the index defination. As it is always recommended
Hmm, hmm, .... What makes you belive this? It will definately NOT HAVE ANY INFLUENCE WHATSOEVER in the speed of retrival of data if you specify the sequence of the columns in the WHERE condition as you specified in the index defination. The order of conditions in WHERE close is irrelevant.