Sanz (2/8/2010)
I have a huge table in my database. I need to delete records from this table. There are no indexes on this table. If I create an index on one of the columns the deletion process will run faster but the index creation will take a long time.I need to know the best method to delete rows from this table.
Thanx in Advance !
Do you have a primary key on this table? I'm asking because a lot of folks don't know that a Primary Key also makes an index.
--Jeff Moden
Change is inevitable... Change for the better is not.