Reputation
464
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 8 23
Impact
~38k people reached

Apr
7
awarded  Famous Question
Jan
2
awarded  Notable Question
Nov
24
awarded  Notable Question
Aug
14
awarded  Popular Question
Jul
2
awarded  Curious
Jun
27
awarded  Notable Question
May
27
awarded  Notable Question
Feb
19
awarded  Popular Question
Jan
9
awarded  Popular Question
Dec
19
awarded  Citizen Patrol
Dec
16
awarded  Yearling
Jun
17
awarded  Popular Question
May
14
awarded  Caucus
May
8
comment How can I get this query to use it's index?
sigh even if I remove the OR ie removed this part: ` languageId = 3 AND isActive = 1 AND modifiedDateTime > '2013-05-05 23:00:00.0' ` I still get Using where
May
8
comment How can I get this query to use it's index?
This particular query returns 16 rows. It took 9.24 seconds the first time I ran it.
May
8
comment How can I get this query to use it's index?
Removed the ORED BY an ran explain again. See edit
May
8
revised How can I get this query to use it's index?
added 506 characters in body
May
8
comment How can I get this query to use it's index?
Tried this and unfortunately the explain still shows Using where. Is there a way to encourage the optimizer to us Index-Merge?
May
8
asked How can I get this query to use it's index?
May
7
awarded  Quorum