A table has 1 trillion records.
A process deletes all records retaining 100 records. Stats are gathered on table.
When we say select * from table will it returns rows faster? If no, how can we make it faster?
What is the fastest way of deleting records in the above scenario?
Conversely, If we have to delete only 100 records and retain remaining records how can it be done in efficient manner