434 reputation
622
bio website kiva.org
location Sweden
age 46
visits member for 3 years, 6 months
seen Jul 17 at 12:51

A lazy sysadmin/coder


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
Apr
17
accepted Can I make sure two columns dont have the same value
Apr
13
revised Can I make sure two columns dont have the same value
added 2 characters in body
Apr
13
asked Can I make sure two columns dont have the same value
Mar
1
awarded  Notable Question