|
|
|
|
|
|
by scotty79
1208 days ago
|
|
|
If some field is referenced in WHERE clause, add an index for it. If there are a few fields referenced in a single WHERE add a single index that includes all of them. If you have index that has a, b, c then it is as if you also had indexes a, b and a. If condition in WHERE is = put this field at the beginning of an index. If it's < (or similar) put it at the end. You'll get best results if you have none or only one < in your query. |
|
|