Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-17 Thread Pablo M. Rivas
Hello Ross, why don't use: explain select . and you'll see what mysql is "thinking"... ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-16 Thread Jason Wong
On Saturday 17 July 2004 09:31, Ross Honniball wrote: > Attention all Sql gurus, > > Is there a way to FORCE mysql resolve specific conditions within a query > before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Op

[PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-16 Thread Ross Honniball
Attention all Sql gurus, Is there a way to FORCE mysql resolve specific conditions within a query before wasting it's time trying to resolve other conditions? I THINK mssql is behaving foolishly in the way it goes about resolving the following situation. Tables : BN_SupMast : Reference table jo