Help - Optimizing DELETE performance - not understanding COMMENTS from projection_delete_concerns
We are trying to Optimizing DELETE performance having table with 300 columns and we do batch load every 5 hours.
we did EVALUATE_DELETE_PERFORMANCE and checked comments from v_catalog.projection_delete_concerns is like this "
Please see "Optimizing Deletes for Performance" in the Administrator's Guide. The squared number of rows matching each sort key is about 3326 on average."
we found no information given guide and back to square one.
Please help, how to understand this comment and what is needed to optimize DELETE.