title: Oracle delete query taking long time to delete the records from the table
body: <p>Query:
  <code>Delete from test_table;</code>    (i am using this delete command in Procedure to perform daily)</p>
  
  <p>This table contains 2 column name like scenario_id, item_id, these 2 column are composite primary key. So Each scenario_id will have 2 millions item_id, How to delete this table quicky.</p>