By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

primary key problem on delete

100+
P: 138
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
May 25 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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?
May 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.