title: Netezza Groom table is not removing deleted records
body: <p>Below is the tested SQL code in Aginity that i have tried to track how grooming table works but i have checked it several times and to my surprise deleted records does exists in the table. Is there any time frame for them to be removed?</p>
  
  <pre><code>--1382159 records
  
  SELECT COUNT(*) FROM AS_TEST_WORK;
  
  --1111 records deleted
  
  DELETE FROM AS_TEST_WORK WHERE rrn_num LIKE '324%'; 
  
  --setting deleted records for a display
  
  SET show_deleted_records = true;  
  
  --So i can see the deleted records
  
  SELECT createxid, deletexid, COUNT(*) from AS_TEST_WORK GROUP BY 1, 2 ORDER BY 1;
  
  --Groom table command to remove the deleted records permanently
  
  GROOM TABLE as_test_work records all;  
  
  --Re confirming by setting for a display
  
  SET show_deleted_records = true; 
  
  --To my surprise i can still see the deleted records
  
  SELECT createxid, deletexid, COUNT(*) from AS_TEST_WORK GROUP BY 1, 2 ORDER BY 1; 
  </code></pre>