[TYPO3-v4] List module improvements

Dmitry Dulepov dmitry.dulepov at gmail.com
Mon Mar 7 15:35:25 CET 2011


Hi!

Jigal van Hemert wrote:
> The opposite is actually true: if there are not enough different pids
> (low cardinality) it is faster to do a full table scan (chances are that
> you need to retrieve a lot of records anyway) than to use an index.

Why would you do a full table scan if the table has a proper index on a 
sorting column?

-- 
Dmitry Dulepov
TYPO3 core&security team member
E-mail: dmitry.dulepov at typo3.org
Web: http://dmitry-dulepov.com/


More information about the TYPO3-project-v4 mailing list