Re: A proper FAQ - Wish fulfillment

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 10 Mar 2003 15:30:12 -0000
Message-ID: <b4ib33$gkc$1$8300dec7@news.demon.co.uk>

It's not just the infinitesimal amount of time, it's the three buffer accesses and cache buffers chains latch acquisitions, too.

( Of course, it does reduce your buffer cache hit ratio - but you'll just have to put up with that in the interests of improved efficiency ;) ( NB irony (-- which is nothing like steely or goldy))

--
Regards

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

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____UK_______April 8th
____UK_______April 22nd

____USA_(FL)_May 2nd


Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____UK_(Manchester)_May
____USA_(CA, TX)_August


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


"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message news:3e6ca15e$0$227$ed9e5944_at_reading.news.pipex.net...


>

> Good point, and there is of course yet another version (which saves

an


> infinitesimal amount of time)

>

> insert into t values(seq_t.nextval,'hola');

>

>

Received on Mon Mar 10 2003 - 09:30:12 CST