cancel
Showing results for 
Search instead for 
Did you mean: 

Using Keys in Combination vs Individually for more Complex Queries?

Questions:

- Can it be better to get one key to each column, a combo of columns depending on the combinations required in a question, or a set of columns under one key?

 

- does with all the above mentioned affect the speed/efficiency of this question, versus only with the keys needed according to the EXPLAIN outputsignal?

 

- Are there any ways to utilize indexes/keys INCORRECTLY that will interfere with the operation greater than simply not using them?

 

Thank you!

omegle online chat

jamessmith123
Member
0 REPLIES 0