meta user
network profile
|
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 |
|
Feb 23 |
accepted | Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes |
|
Jan 30 |
revised |
Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes added 27 characters in body |
|
Jan 30 |
asked | Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes |
|
Jan 28 |
awarded | Popular Question |
|
Nov 12 |
awarded | Popular Question |
|
Sep 19 |
awarded | Popular Question |
|
Aug 24 |
awarded | Commentator |
|
Aug 24 |
comment |
Any reasons at all *not* to use MySQL in this scenario No it came down to migration issues. The suppliers claim that migrating to mssql was easy (or indeed possible) was higly exaggerated. |
