3 ms·
I think that might be too optimistic - it went from a table with thousands of records to hundreds of millions of records. If I were to speak technically the or
by SketchySeaBeast 7y ago
I think that might be too optimistic - it went from a table with thousands of records to hundreds of millions of records. If I were to speak technically the oracle optimizer "did a derp".
- PeterisP 7y agoSo... stale statistics? I.e. the optimizer making the query plan assuming that the table has thousands of records (because that's what it had earlier) and now it has hundreds of millions of records? A sudden order of magnitude change in table sizes isn't normal operation, for most DB platforms that requires running some "everything's different now, please recalculate statistics" command to maintain proper functioning.