I expand that rule slightly: no changes to production on the day before I will be absent from the office.
Makes for so many fewer "emergency" phone calls on my day off --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > That is very wise advice. Don't touch production on Fridays has been > a rule > in previous shops I worked at. Happy Friday all! <pow> > > Lisa Koivu > Oracle Database Supermom to 4 Boys. > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > > -----Original Message----- > > From: Robson, Peter [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, December 06, 2002 10:30 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: sql tuning help > > > > > > Hmmmmmmm - this is a Friday afternoon, you know. My suggestion is > to > > forget > > it until Monday - don't spoil your weekend.... > > > > > > peter > > edinburgh > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > Sent: 06 December 2002 12:54 > > > To: Multiple recipients of list ORACLE-L > > > Subject: sql tuning help > > > > > > > > > Hi, > > > > > > Oracle 8.1.6 NT 4.0 > > > > > > I have a rather complex query a developer gave to me to try to > improve > > > performance. > > > There are 3 tables used. All relevant columns used are > > > indexed. The tables > > > have been analyzed > > > > > > SQLWKS> select count(*) from physicians; > > > COUNT(*) > > > ---------- > > > 340043 > > > 1 row selected. > > > SQLWKS> select count(*) from boards; > > > COUNT(*) > > > ---------- > > > 220 > > > 1 row selected. > > > SQLWKS> select count(*) from phy_boards; > > > COUNT(*) > > > ---------- > > > 450674 > > > > > > Below is the sql statement and explain plan. > > > I see one FTS on 440,000+ records but cannot tell exactly > > > what statement it > > > is and how to resolve > > > > > > Any suggestions on how to optimize is appreciated. > > > > > > Thanks > > > Rick > > > > > > select board_other.description strBrdNameOtherTHQuest > > > ,decode(board_aaps.description, null,' ','X') ysnAAPSBoard > > > ,decode(board_aba.description, null,' ','X') ysnABABoard > > > ,decode(board_abem.description, null,' ','X') ysnABEMBoard > > > ,decode(board_abfp.description, null,' ','X') ysnABFPoard > > > ,decode(board_abim.description, null,' ','X') ysnABIMBoard > > > ,decode(board_abp.description, null,' ','X') ysnABPBoard > > > ,decode(board_abr.description, null,' ','X') ysnABRBoard > > > ,decode(board_aobem.description, null,' ','X') > ysnAOBEMBoard > > > ,decode(board_aobfp.description, null,' ','X') > ysnAOBFPBoard > > > ,decode(board_aobim.description, null,' ','X') > ysnAOBIMBAoard > > > ,decode(board_aobr.description, null,' ','X') ysnAOBRBoard > > > ,decode(board_other.description, null,' ','X') > ysnOtherBoard > > > from physicians p > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN ASSOCIATION OF > PHYSICIAN > > > SPECIALIST%') board_aaps > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN BOARD OF > > > ANESTHESIOLOGY%') > > > board_aba > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN BOARD OF > > > EMERGENCY MEDICINE%') > > > board_abem > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN BOARD OF FAMILY > > > PRACTICE%') > > > board_abfp > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN BOARD OF > > > INTERNAL MEDICINE%') > > > board_abim > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN BOARD OF > PEDIATRICS%') > > > board_abp > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN BOARD OF > RADIOLOGY%') > > > board_abr > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN OSTEOPATHIC > > > BOARD OF EMERGENCY > > > MEDICINE%') board_aobem > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN OSTEOPATHIC > > > BOARD OF FAMILY > > > PHYSICIANS%') board_aobfp > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN OSTEOPATHIC > > > BOARD OF INTERNAL > > > MEDICINE%') board_aobim > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and b.description like 'AMERICAN OSTEOPATHIC BOARD OF > > > RADIOLOGY%') board_aobr > > > ,(select distinct pb.phy_id, b.name, b.description > > > from phy_boards pb, boards b > > > where pb.board_id = b.board_id > > > and (pb.expiration_date >= sysdate or > > > pb.expiration_date is null) > > > and (b.description not like 'AMERICAN ASSOCIATION > > > OF PHYSICIAN > > > SPECIALIST%' and > > > b.description not like 'AMERICAN BOARD OF > > > ANESTHESIOLOGY%' > > > and > > > b.description not like 'AMERICAN BOARD OF > EMERGENCY > > > MEDICINE%' and > > > b.description not like 'AMERICAN BOARD OF FAMILY > > > PRACTICE%' and > > > b.description not like 'AMERICAN BOARD OF > INTERNAL > > > MEDICINE%' and > > > b.description not like 'AMERICAN BOARD OF > > > PEDIATRICS%' and > > > b.description not like 'AMERICAN BOARD OF > > > RADIOLOGY%' and > > > b.description not like 'AMERICAN OSTEOPATHIC > BOARD OF > === message truncated === __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
