Hi Team,
I have a huge table shop_cart. it has around 110 million rows and it has data from last 8 years.
I have a requirement to delete data older than 6 months based on column session_date. which is around 90 million rows.
This table is online. And every second 10 to 15 rows inserted in this table.
I am trying to delete rows from shop_cart table in dev. Tried different methods
like
1. use parallel in query.
2. try to delete by selecting less data using rownum<10000.
3. try to delete using one month data
BUT NOT able to do. because every time its doing full table scan.
Can anyone suggest best method to delete data from this table.
Please note column session_date does not have any index.
Thanks in Advance.