What are pros and cons of new feature?
I'm worried about repairing/optimizing a 2 millions records table, wich is currently very, very slow.
Will miss RecordCount with no stats?
Will affects query performance?

Thanks

Tiago,

<< I'm worried about repairing/optimizing a 2 millions records table, wich
is currently very, very slow. >>

You'll have to test it to be sure, but it should be faster without the
statistics.

<< Will miss RecordCount with no stats? >>

With ranges, yes.  You'll also lose the logical record numbers.  But, with
filters and tables without any filters or ranges you'll still see accurate
record counts.

<< Will affects query performance? >>

Possibly, yes.  It depends upon how much the query in question is relying on
the I/O cost calculations to determine the optimal way to execute the query.

--
Tim Young
Elevate Software
www.elevatesoft.com