Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> re creating a primary key on a table makes requests faster?
Hello,
Would their be any reason why removing a primary key and recreating it on a
reasonibly large table (~160000 records and increasing at steady rate, with
int, nvarchar, bit and datetime columns), would have an impact on select and
insert performance?
Is there some kind of fragmentation on a table that could explain this?
thanks in advance for your insight
Received on Mon Dec 17 2007 - 04:26:12 CST
![]() |
![]() |