On Fri, 2006-05-26 at 09:57, Emi Lu wrote:
> Scott Marlowe wrote:
>
> >On Fri, 2006-05-26 at 09:51, Emi Lu wrote:
> >
> >
> >>Emi Lu wrote:
> >>
> >>
> >>
> >Tried to run:
> >
> >delete from tableA where id <60;
> >
> >It is extremely slow.
> >
> >id is intege
Scott Marlowe wrote:
On Fri, 2006-05-26 at 09:51, Emi Lu wrote:
Emi Lu wrote:
Tried to run:
delete from tableA where id <60;
It is extremely slow.
id is integer and also the primary key. tableA has around 9
records.
(I do not want to run truncate since I have some foreig
On Fri, 2006-05-26 at 09:51, Emi Lu wrote:
> Emi Lu wrote:
>
> >
> >>> Tried to run:
> >>>
> >>> delete from tableA where id <60;
> >>>
> >>> It is extremely slow.
> >>>
> >>> id is integer and also the primary key. tableA has around 9
> >>> records.
> >>>
> >>> (I do not want to run trun
Emi Lu wrote:
Tried to run:
delete from tableA where id <60;
It is extremely slow.
id is integer and also the primary key. tableA has around 9
records.
(I do not want to run truncate since I have some foreign key constraint
setup based on tableA. Besides not all data I want to de
Tried to run:
delete from tableA where id <60;
It is extremely slow.
id is integer and also the primary key. tableA has around 9 records.
(I do not want to run truncate since I have some foreign key constraint
setup based on tableA. Besides not all data I want to delete; only part
of
"Emi Lu" <[EMAIL PROTECTED]> wrote
> Hello,
>
> Tried to run:
>
> delete from tableA where id <60;
>
> It is extremely slow.
>
> id is integer and also the primary key. tableA has around 9 records.
>
> (I do not want to run truncate since I have some foreign key constraint
> setup based on
