Re: dbexport/dbimport problems
In article <1995Jan23.130106.17629@bilpin.co.uk>, tony@bilpin.co.uk (Tony Desborough) writes:
|> Hi,
|>
|> We have a production database that has been live for about a
|> year. Application performance on this database has been fine.
|>
|> As the number of extents for some tables was becoming excessive,
|> a full dbexport/dbimport was carried out on the database. Although
|> no problems were experienced during the export/import, once the
|> system was live again, the performance had degraded *significantly*.
|> After a days use, the performance is still awful. I had expected
|> the performance to increase.
|>
|> Has anyone had similar experiences following a dbimport, or can
|> anyone explain what the problem may be.
Try running "update statistics". I seem to remember we had similar problems
which were resolved in this way
|
+--------------------------------------+-----------------------------------+
| Motorola | |
| International Cellular Subscriber | Phone + 44 (0)31-469-6969 |
| Easter Inch, Bathgate | Fax + 44 (0)31-469-6970 |
| West Lothian EH48 2EH | |
| SCOTLAND | |
+--------------------------------------+-----------------------------------+