Too elementary ... but,
Have you done a runstats on the table including the indexes ?
Cheers
Sathyaram
Quote:
Originally posted by David2002
Hi
I work with db2 7.2 AIX, I need to delete some rows from a large table with 20 mil records I use
delete from TAB-A where co11= 'A';
I have index on col1 but it takes long about 1/2 hours that is not acceptable, Some body suggested me I deaclare cursor and use "where current cursor cursor-name" in my delete sql statement. any idea and help will be appreciated.
Thanks
|