Hi

I have a table called SHOPPER which is accessed by my first page of the web site. It actually checks whether the user has been to the iste before or not. When a user comes he may or may not register the status of which is shown in one column as Y or N .

This table is 2.9 million rows and I wish to delete appx 1.1 million rows. The problem i sthis is my PROD database and when i did a delete yesterday for about 20,000 rows the webiste cannot be accessed during that delete .

is there a way I can delete without locking the table or any other way in which I can delete these rows without affecting the website.

Thanks