2 added 170 characters in body
source | link

No, it won't help. If Field4 were the first column, then it would have helped. Like asking if going through a telephone directory/book will help you sort peoples names by firstname. :-)

Edit: Erik posted one example where this index can help. Requires you to return all of the rows for a certain Field4 value (i.e., equal-comparison on all but Field4).

No, it won't help. If Field4 were the first column, then it would have helped. Like asking if going through a telephone directory/book will help you sort peoples names by firstname. :-)

No, it won't help. If Field4 were the first column, then it would have helped. Like asking if going through a telephone directory/book will help you sort peoples names by firstname. :-)

Edit: Erik posted one example where this index can help. Requires you to return all of the rows for a certain Field4 value (i.e., equal-comparison on all but Field4).

1
source | link

No, it won't help. If Field4 were the first column, then it would have helped. Like asking if going through a telephone directory/book will help you sort peoples names by firstname. :-)