[TYPO3-dev] Testing TYPO3 caching vs.[FE][pageCacheToExternalFiles]

[Dimitri Tarassenko]

Marc,

On 3/31/06, "Marc Wöhlken [quadracom]" <woehlken at quadracom.de> wrote:

> > Doesn't it use statistical data gathered by ANALYZE TABLE?
> Yes, it does use this data. But analyze just recalculates the
> cardinality of an index it does not give information about how many rows
> will match one certain index value.

It does, in a way. I would not vouch for MySQL, but in real SQL
servers query planners use total number of records in the index, as
well as try to predict the resulting number of rows guessing the type
of distribution the values in the index have.

--
Dimitri Tarassenko