SQLT providing incorrect information on table stats
Hi,
We installed SQLT and used the XTRACT method passsing on the SQL_ID of the statement we were interested in fine tuning
In the main report section, it reported the following
APP.BROKER_REF
Number of rows equal to zero according to table's CBO statistics
[+] Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See Note 465787.1.
TABLE APP.CONTAINER
Table CBO statistics are 386 days old: 2009-08-13/22:00:36
[+] Consider gathering fresh table statistics with a sample size of at least 100%.
TABLE
APP.ENTITY Table CBO statistics are 385 days old: 2009-08-14/22:02:00
[-] Consider gathering fresh table statistics with a sample size of at least 100%.