maria-discuss team mailing list archive
Mailing list archive
Re: EXPLAIN and CONNECT
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).