Reputation
484
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 9 25
Newest
 Caucus
Impact
~47k people reached

Aug
4
awarded  Caucus
Aug
4
awarded  Constituent
Jun
29
awarded  Self-Learner
May
1
awarded  Famous Question
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