How about -
Oracle's decision to use an index for a
query is determined by the percentage
of rows from the table identified by the
index.
Hints are only suggestions and Oracle
is allowed to ignore them
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: 13 March 2002 17:02
|Yep, had that one... another of my fav's!
|
|Robert G. Freeman - Oracle8i OCP
|Oracle DBA Technical Lead
|CSX Midtier Database Administration
|
|The Cigarette Smoking Man: Anyone who can appease a man's conscience
can
|take his freedom away from him.
|
|
|
|-----Original Message-----
|Sent: Wednesday, March 13, 2002 8:28 AM
|To: Multiple recipients of list ORACLE-L
|
|
|And the time honoured favourite...
|
|"All performance problems can be resolved by
|modification of init.ora parameters, in particular,
|any parameter that starts with an underscore"
|
| --- Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
|wrote: >
|> My next to favourite legends.
|>
|> Small tables don't need to be indexed
|>
|> Small tables are anything 4 blocks or less
|>
|> Oracle copies the entire row into the rollback
|> segment when updating a single column.
|>
|> Oracle copies the entire block into the rollback
|> segment when updating a row.
|>
|> Oracle can only use 5 indexes in a query
|> (though I haven't heard that one much
|> recently)
|>
|> Setting tablespace default pctincrease to 1
|> reduces
|> fragmentation problems.
|> (but that's going out of fashion too)
|>
|> But I guess you, Jeremiah and Rachel have
|> already got those covered.
|>
|>
|>
|> Jonathan Lewis
|> http://www.jlcomp.demon.co.uk
|>
|> Next Seminar - UK, April 3rd - 5th
|> http://www.jlcomp.demon.co.uk/seminar.html
|>
|> Host to The Co-Operative Oracle Users' FAQ
|> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
|>
|> Author of:
|> Practical Oracle 8i: Building Efficient Databases
|>
|>
|> -----Original Message-----
|> To: Multiple recipients of list ORACLE-L
|> <ORACLE-L_at_fatcity.com>
|> Date: 12 March 2002 22:54
|>
|>
|> |Everyone, some great ideas....
|> |
|> |RF
|> |
|> |Robert G. Freeman - Oracle8i OCP
|> |Oracle DBA Technical Lead
|> |CSX Midtier Database Administration
|>
|>
|> --
|> Please see the official ORACLE-L FAQ:
|> http://www.orafaq.com
|> --
|> Author: Jonathan Lewis
|> INET: jonathan_at_jlcomp.demon.co.uk
|>
|> Fat City Network Services -- (858) 538-5051 FAX:
|> (858) 538-5051
|> San Diego, California -- Public Internet
|> access / Mailing Lists
|>
|--------------------------------------------------------------------
|> 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).
|
|=====
|Connor McDonald
|http://www.oracledba.co.uk (mirrored at
|http://www.oradba.freeserve.co.uk)
|
|"Some days you're the pigeon, some days you're the statue"
|
|__________________________________________________
|Do You Yahoo!?
|Everything you'll ever need on one web page
|from News and Sport to Email and Music Charts
|http://uk.my.yahoo.com
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: =?iso-8859-1?q?Connor=20McDonald?=
| INET: hamcdc_at_yahoo.co.uk
|
|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing
Lists
|--------------------------------------------------------------------
|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).
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Freeman, Robert
| INET: Robert_Freeman_at_csx.com
|
|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing
Lists
|--------------------------------------------------------------------
|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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: jonathan_at_jlcomp.demon.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mar 13 2002 - 11:53:29 CST
