SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:58 PM
| ||||
| ||||
 RUNSTATS taking looong time Need urgent help... I am trying to make a change in one column (primary key). I dropped the primary key which dropped other 2-3 foreign keys referencing this column. I made the changes. Re-built Primary key as well as Foreign keys which were dropped. Now, many packages were invalid. So, I did rebound all those packages. After all these, I tried to run RUNSTATS (with distribution and all indexes) on all tables and it is taking LOOOOOONG time than it used to take usually (all tables are taking loooong time including those tables which are NOT at all involved in this change). Can anyone help me in understanding this and to overcome this looong time runstats PLEASE?      |
|
02-26-2008, 05:58 PM
| ||||
| ||||
| Re: RUNSTATS taking looong time "Kumar" <kumar@tumkurcity.com> wrote in message news:2fa6f746.0405101225.abd8d2f@posting.google.co m... > Need urgent help... > > I am trying to make a change in one column (primary key). I dropped > the primary key which dropped other 2-3 foreign keys referencing this > column. > > I made the changes. > > Re-built Primary key as well as Foreign keys which were dropped. > > Now, many packages were invalid. So, I did rebound all those packages. > > After all these, I tried to run RUNSTATS (with distribution and all > indexes) on all tables and it is taking LOOOOOONG time than it used to > take usually (all tables are taking loooong time including those > tables which are NOT at all involved in this change). > > Can anyone help me in understanding this and to overcome this looong > time runstats PLEASE? Probably running short of space on system temporary tablespace. Other things to look at include the sortheaps. |
Linear Mode
