Hi,
Have you tried changing the date format like
delete from TelecomAccountPosting where LocID=19014 and InvDate='2008-01-15';
I know it shouldn't matter but I have had similar issues due to the date
format.
Also are you sure there are 3773 records matching this criteria - according to
your t
On Tue, 2008-01-22 at 11:23 +1100, Chris wrote:
> > Why is it saying 'Impossible WHERE noticed after reading const tables'?
>
> http://dev.mysql.com/doc/refman/4.1/en/explain.html
> MySQL has read all const (and system) tables and notice that the WHERE
> clause is always false.
>
> ie - no rows
Daniel Kasak wrote:
Greetings.
I have a script which seems to be bringing our server to its knees.
I've isolated one query which is doing it:
delete from TelecomAccountPosting where LocID = 19014 and InvDate =
'20080115';
I have an index which covers both LocID and InvDate:
CREATE TABLE `Tel
Greetings.
I have a script which seems to be bringing our server to its knees.
I've isolated one query which is doing it:
delete from TelecomAccountPosting where LocID = 19014 and InvDate =
'20080115';
I have an index which covers both LocID and InvDate:
CREATE TABLE `TelecomAccountPosting` (