nice :) no problems in this case i wasn't considering this i will check if documentations have this, serious i don't remember if something simple like this is explained and i never checked before :)
if i don't found this information, i will reply here 2014-05-26 19:52 GMT-03:00 Sergei Golubchik <s...@mariadb.org>: > 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 > -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
