Thread: ANALYZE for a schema

 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 ?

Andrus.

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