[TYPO3-dev] Optimizing last 20 query

[John Angel]

Hi Dmitry,

I was wondering why mysql doesn't use index when having t3ver_state in it?

This is working:

ALTER TABLE pages ADD INDEX `excerpts` ( 
pid,nav_hide(1),deleted(1),hidden(1),crdate);

This is not working:

ALTER TABLE pages ADD INDEX `excerpts` ( 
pid,nav_hide(1),deleted(1),t3ver_state(1),hidden(1),crdate);


Original SELECT has:
...
AND pages.deleted =0
AND pages.t3ver_state !=1
AND pages.hidden =0
...
so it is natural to add t3ver_state?

Regards,
John