Re: Drop Index takes longer in Prod than in Test

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: somckit.khemmanivanh@xxxxxxxxxxxxxxxx
  • Date: Wed, 13 Sep 2006 19:31:50 +0100

look at statspack for the affected time period, see if anything pops out.

Else you are stuck with tracing - i dont seem the problem in enabling it,
multi tiered isnt a problem, just start a trace at the database level

On 13/09/06, Khemmanivanh, Somckit <somckit.khemmanivanh@xxxxxxxxxxxxxxxx> wrote:

The index drops can sometimes take minutes in prod -- whereas as test of the same drop, in the test environment, takes seconds. Now minutes might not seem like much, but there are many indexes so the times add up.

Other related posts: