Re: MyISAM using 'wrong' index
Hi Rick,
The server has 64GB RAM, running on SSD's in RAID 10. So I/O shouldn't be the issue.
Regaring the left join: normally I do select data from the joined table, just removed it here to simplify the situation.
OPTIMIZE is executed every night, so statistics should be up to date. So I guess there's isn't anything I can do about this?
Thanks,
Danny
Subject
Views
Written By
Posted
2132
June 08, 2015 04:14AM
1206
June 09, 2015 11:53PM
1745
June 30, 2015 03:22AM
1382
July 02, 2015 09:28PM
Re: MyISAM using 'wrong' index
1266
July 03, 2015 03:16AM
1380
July 04, 2015 11:10AM
1303
July 07, 2015 01:56AM
1121
July 07, 2015 09:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.