which is more beneficial schema stats or table stats or database stats?
and when a query is fired optimizer looks for what stats table stats or schema stats to execute the query?
what is the first stats preference of optimizer??