The biggest problem I have with articles like this is that they are incomplete. You start an idea and never follow through to the end of the idea. This typical...

No offense but the question looks like a query a beginner would do. I think a better question would be what index would put on the table to optimize...