Re: Granting table privileges

"Peter" <no_email_at_no_email.com> wrote in message news:<b72guq$rch$1_at_bunyip.cc.uq.edu.au>...
> You live and learn :) and I guess learning is what makes a good DBA.
>
> I guess if people are aware that by default, separating tables and indexes
> is not necessary then that is good.
>
> From an administrative point of view it does quite often make things easier
> and as database administrators this can sometimes be quite important.
>
> The bottom line is if you are having performance issues then tune your
> database to fix it; find the hot spots and take appropriate action.

Isn't the issue physical database layout to proactively avoid the performance problems?

And isn't it important to define what those problems might be? Multiuser contention negating separation advantages is a red herring when management is upset that month-end overnight update/reporting or periodic MRP runs take too long - and it could have been avoided.

Of course, I don't have a problem with coming in later to fix other people's problems, as long as I get the big bucks! :-)

jg

--
@home.com is bogus.
Although, I'd still really like to just get a fair wage to do it right
up front.  (sings) I'm a, daydream believer...