For those who specify either the ALL_ROWS or even the FIRST_ROWS(n) trace inside a SQL statement, and if the data dictionary does not have stats about tables accessed through the assertion, then the optimizer uses default statistical values, like allotted storage for this sort of tables, to estimate the lacking http://businessdirectorywebsite16937.blogoscience.com/9573685/the-basic-principles-of-should-you-force-indexing