Andrus wrote:
I have multi company database where each company is stored in different
schema.
When I create incrementally new companis and add data to it ANALYZE command
takes a lot of time: every time it analyzes the previous company data also.
How to run ANALYZE command for a single schema ?
You can run ANALYZE on single tables, so it should be simple enough to
write a script to get a list of all tables in the new schema and analyse
each one.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings