[TYPO3] Indexed search query optimization

[Jan Bednarik]

> When you have "like '%whatever%'", you can forget about indexes. They 
> will not be used because it does not make sense with '%...%'. It is 
> always the whole table scan. Change search mode to exact or beginning. 
> It will get rid of at least the first %.

Well, then it's not indexed search anymore. It wouldn't be able to find 
all matches.

I've found out that index_rel table has about 6 milion of rows.

-- 
Jan Bednarik
www.bednarik.org - web about Typo3 in czech