RE: skip scan index

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 28 May 2003 07:04:58 -0800
Message-ID: <F001.005A433F.20030528070458@fatcity.com>

Dick,

I club him regularly... doesn't seem to get through. As someone (Bill Thater) once said on the OT list.. this guy wouldn't be able to spot a clue, in a clue field, during clue mating season while drenched in clue pheronomes.

I fight all the time with him. I win :). My basic premise is "It's MY database, keep your hands off it and let the DBA do her job"

Rachel

• "Goulet, Dick" <DGoulet_at_vicr.com> wrote:
  > Rachel,
  >
  > I'll send you a baseball bat to club that duhveloper over the head
  > with. Your right, skip scan is a method that Oracle uses to make use
  > of an index when logically it should not. You cannot specify it that
  > way. Darn duhvelopers who read things into manuals, it's dangerous
  > for them.
  >
  > Dick Goulet
  > Senior Oracle DBA
  > Oracle Certified 8i DBA
  >
  

  ---

Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed May 28 2003 - 10:04:58 CDT