[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