Grouper Developers Forum

[Jim Fox <>]

> > I suppose a real DBA would have known, but ANALYZE also can greatly
> > affect
> > the efficiency of queries.  After doing an analyze on the three
> > tables the
> > search with a user session is about the same as the root session.
> >
> > We live and learn I guess.  I'll add more groups and users to the
> > database
> > and see what happens.
>
>
> Ok cool.  Though I thought you said you ran analyze in your last
> email. :)  Did you have to run it more than once or did you run it
> with different parameters the second time?

No.  The problem is that I didn't realize the dramatic effect of analyze.

It only needed to be run once.  And again, after any major additions to 
the tables.

Jim