Re: Microsoft destroys TPC-C records!

You always use HINT in writing SQL?

> Because it's very hard for a db to fully understand the applications
> that are running against and the users who use the db. After all, how is
> the db to know that I plan on performing a major load this weekend? Or
> that for the next week, I'll be experiencing a 50% increase in the
> number of users?

But the db know the data distribution which I think DBAs, developers or users may not exactly know.

In comp.databases.sybase Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

> Out of ALL the comments I made in my last post, this is the only thing
> you could come back with? I'm well aware of the workings of rule based
> and cost based optimization. Maybe you've heard of a little thing called
> the EXPLAIN PLAN and it's companion, the HINT?!?! My point was that cost
> based optimization does not always choose the best path. It's nice to be
> able to use hints to change the path. I'd rather have that flexibility
> at my fingertips than to have the db make all the decisions for me.
> That's the point of the majority of my comments.
 

> Thanks,
> Brian

> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================

-- 
http://www.cooper.com.hk