Flashback Query ‘AS OF’ – Tablescan costs

(Randolf Geist) This is just a short note prompted by a recent thread on the OTN forums. In recent versions Oracle changes the costs of a full table scan (FTS or index fast full scan / IFFS) quite dramatically if the “flashback query” clause gets used.

Read More - Register for Free Membership