135 reputation
5
bio website rockyprep.com
location Colorado
age 36
visits member for 1 year, 3 months
seen Apr 11 at 2:39

Living the dream.


Jun
28
comment How can I speed up this slow simple query?
@ypercube I understand and agree the advice is good. I appreciate the extra explanation as well and see your point about how to better construct the query. Thanks again.
Jun
26
comment How can I speed up this slow simple query?
@Clockwork-Muse Thanks for the warning, but it doesn't apply in this instance because my data is really in August-May, so there's no risk of ever being cutoff wrongly by BETWEEN. But I appreciate the knowledge so it doesn't affect my future cases.
Jun
25
comment How can I speed up this slow simple query?
@ypercube The old OR query is still not any faster with the new indexes. You were correct to assume hometeam and awayteam will never be the same. Thank you very much for your help and the extra mile with the why explanation.
Jun
25
accepted How can I speed up this slow simple query?
Jun
25
awarded  Supporter
Jun
25
comment How can I speed up this slow simple query?
Wow! Less than 0.002 seconds. Amazing! My question is why is it faster to select twice and union than my simple OR?
Jun
25
asked How can I speed up this slow simple query?
Jun
25
awarded  Informed
Dec
27
awarded  Scholar
Dec
27
accepted Swap Columns on some rows?
Dec
27
awarded  Student
Dec
26
asked Swap Columns on some rows?
Dec
25
awarded  Autobiographer