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:
