The 'STRAIGHT_FORWARD' + 'FORCE INDEX' worked, thanks a lot to all :)
Tristan
--
Tristan Marly
06.16.84.57.43
http://www.linkedin.com/in/tristanmarly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Selon Rob Wultsch [EMAIL PROTECTED]:
http://www.google.com/search?q=STRAIGHT_FORWARD+mysql yields buckus.
Where is this documented?
oops, I meant 'straight_join' :/
Tristan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm still trying to decript the EXPLAIN result, and there is something I really
don't understand:
mysql EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media WHERE
country.id='Germany' AND country.detail_tid=content.tid AND
content.id=media.content_id;
On the FAST server:
Hi,
I have 2 MySql server instances. One which is 5.0.27/Debian, another
5.0.32/Solaris.
Both instances have the same data in the database.
And I'm doing a select:
SELECT media.* FROM media,country,content WHERE country.id='Germany' AND
country.detail_tid=content.tid AND