Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> re creating a primary key on a table makes requests faster?

re creating a primary key on a table makes requests faster?

From: Wilfrid <grille11_at_yahoo.com>
Date: Mon, 17 Dec 2007 11:26:12 +0100
Message-ID: <47664eca$0$13391$426a74cc@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US