Delete from table with not exists and not in.
Hi I have something similar to below, each of the table have 300k records, all are going on index path except the EMP table which has date filter is going on FTS. This is taking billions of buffer gets and getting out with ORA-01555. Both underlying tables EMP1 and EMP2 are heavily transactional @400 insert deletes per second.. Can some one let me know what makes this query take so many buffer gets and end up with snapshot too old.
Note: no empty blocks in EMP, both below in sub queries are going with index path. Also tried re writing with NOT IN ( this is select is going faster ). Check the tags for version and other
Tagged:
1