subject:"\[GENERAL\] ANALYZE for a schema"

Re: [GENERAL] ANALYZE for a schema

2006-04-10 Thread Richard Huxton

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 schem

[GENERAL] ANALYZE for a schema

2006-04-08 Thread Andrus

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.