Search code examples
oracleindexingtable-statistics

gathering statistics on tables without indexes


Does it make sense to gather regularly statistics on table without indexes in Oracle database? I'm asking from optimization point of view. I assume that always FULL TABLE SCAN would be performed on that table.


Solution

  • Yes it's still worth gathering the statistics. Information about the number and size of rows is of use to the optimizer, even though there are no indexes