maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Roberto!

On May 26, Roberto Spadim wrote:
> maybe include at extra "estimative rows count"
> just to understand what happened

Row count in the EXPLAIN output is *always* an estimation, there is no
need to specify it explicitly because it is always the case.

> > I suppose you've seen the answer in the bug report. But just for the
> > sake of completeness I repeat it here.
> >
> > CONNECT does not read rows several times. But in the CSV file format,
> > rows can have different lengths and CONNECT cannot directly know how
> > many rows your table has. So, it *estimates* the number of rows by
> > dividing the file length by the minimal row length (which it can
> > calculate from the table definition).

Regards,
Sergei