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
