How reliable is the sql query manager cost value ? Previously neither the Extent or Selectivity fields were set but after running $System.SQL.TuneTable(table,1,1) for all tables, the cost value has increased. I then edited one of the classes and removed the Extent and the cost value went down but not as low as with no Extent and Selectivity values set.
1. So should I be running $System.SQL.TuneTable(table,1,1) 2. I can remove the Extent from a table but how do I remove the Selectivity values ????
