Robert,
I'd advise you to buy a book, but frankly I don't know a good one on DB
performance optimization. The DB optimizers I've met tend to guard
their secrets closely.
Suggestions, anyone?
> i have several friends that are DBA's by profession and work on
> oracle
> and/or ms sql server. they
On Sun, 9 Sep 2001, Josh Berkus wrote:
> > i have several friends that are DBA's by profession and work on
> > oracle
> > and/or ms sql server. they have all told me that while there are some
> > general rules to follow that each database is different.
>
> Yup. They told ya right.
>
> > for e
Stephan,
Ah. Well, you answer optimization questions so often that I'd assumed
that you had a hand in it. Is the optimizer all Tom and Bruce's work?
> At least on 7.1 and below, if you have a dummy value that is very
> common
> but doesn't really pass any information (like 'N/A' for example),
On Sun, 9 Sep 2001, Josh Berkus wrote:
> Ah. Well, you answer optimization questions so often that I'd assumed
> that you had a hand in it. Is the optimizer all Tom and Bruce's work?
Mostly Tom I believe.
> > At least on 7.1 and below, if you have a dummy value that is very
> > common
> > bu
