[coolminded]

hi,
when i update/delete a table with a field which is serial and is a primary key, it takes long time with compare to the field which is just a unique key.
we have almost 500000 data.

but i have to delete it with the primary key any how
can u give suggestion?

thanx in advance

[rski]

Originally Posted by coolminded

hi,
when i update/delete a table with a field which is serial and is a primary key, it takes long time with compare to the field which is just a unique key.
we have almost 500000 data.

but i have to delete it with the primary key any how
can u give suggestion?

thanx in advance

What execution plan does optimizer generate. What does explain command show?