Re: Rules and Cost Based Optimization

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 13:12:37 -0500

You should find a new consultant. The engine is essentially cost based and
there are no rules short of query hints to change the way it optimizes the
query. If you designed a poor database you will probably have less than
optimal performance. But that does not mean you can not tune it. You don't
change the engine you change the way you access the data by making sure you
tune the queries and the schema as best you can. 

-- 
Andrew J. Kelly  SQL MVP
"TABMCSE" <TABMCSE@discussions.microsoft.com> wrote in message 
news:1636125A-4821-4365-80FB-F6492454307A@microsoft.com...
>    I have been trying to find out what optimization method SQL Server 2000
> uses. Of the little that I have found on the subject, indicates that SQL 
> 2000
> uses Cost Based, however, I was told by our consultant that this is 
> incorrect
> and it is really or should really be rules based. I need to find a way to 
> see
> what method we are using and to change it to rules based method to improve
> performance due to the way the database was designed. Please advise. Thank
> you.

Relevant Pages

  • Re: Other JSF options
    ... part of the development cost. ... "Your engine ... Oh, boy...you are worried about the P&W engine being able to meet specs, ... Are you saying that the competition won't hold both ...
    (rec.aviation.military)
  • Re: Richs OT Evil Apple irrational brain fart.
    ... new computer it's already pre-installed and doesn't cost you ... So why don't peole do it, why not buy a ford and put a ferrari engine ... You can do anything you want, if you're prepared to pay for it. ... buying a car as it comes off the assembly line. ...
    (rec.photo.digital)
  • Re: Other JSF options
    ... part of the development cost. ... "Your engine ... Oh, boy...you are worried about the P&W engine being able to meet specs, so ... Are you saying that the competition won't hold both ...
    (rec.aviation.military)
  • Re: Project management and costing
    ... I often change design elements as better ... If you are doing simple product extensions such as making the ... Royce Company with their first jumbo ducted fan jet engine. ... specific/objective/measurable performance goals and cost targets. ...
    (rec.crafts.metalworking)
  • Re: Richs OT Evil Apple irrational brain fart.
    ... computer it's already pre-installed and doesn't cost you anything. ... to pick and chose an engine to their car. ... So why don't peole do it, why not buy a ford and put a ferrari engine ... you can;t buy PCs without a CPU can you? ...
    (rec.photo.digital)