| deleting records [message #190436] |
Wed, 30 August 2006 13:36  |
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
|
Senior Member |
|
|
I´m having problems when i try to delete some records in a table...
I'm doing follow:
delete from table where field like '04%';
and it seems like the computer work but nothing happens.
The table has about 10 millions of records.But i want to delete about 1800 records. I left the delete yasterday afternoon and in the morning the records are in the table.
I delete mi indexes too...
Something has an idea why is that?
thanks
ALex
[Updated on: Wed, 30 August 2006 13:57] Report message to a moderator |
|
|
|
|
|
|
|
| Re: deleting records [message #190657 is a reply to message #190443] |
Thu, 31 August 2006 09:58  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Depending on what server houses your database, it may take days to do a delete like that (Oracle running on a Windows machine like a P3 with 128 Mb memory).
With no index, a FTS on tens of millions of records on a slow PC is not desired.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
