Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Deadly sins againts database performance/scalability

Re: Deadly sins againts database performance/scalability

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 29 Nov 2003 08:52:20 -0000
Message-ID: <bq9n88$cdr$1$8300dec7@news.demon.co.uk>

Answer in-line

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1069957744.97573_at_yasure...

> Niall Litchfield wrote:
>
> > Actually I'm beginning to regret that post now.
> >
> > As Joel rightly says there is a real danger in creating a list like that
> > one. In my case my post might just have suggested that one should always
use
> > bind variables (I believe you could read it that way :) ) and this is of
> > course untrue, one should always use them, except where they are
> > inappropriate.
> >
>
> And they are in appropriate ... when?
>
DSS systems where the queries are few and large, and the optimiser's need for precise inputs is more important than a (relatively) minor increase in CPU and latch costs on parse/optimise.
Received on Sat Nov 29 2003 - 02:52:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US