| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL functions and indexes
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C05932.6E9A59A0
Content-Type: text/plain;
charset="iso-8859-1"
-----Original Message-----
From: O'Neill, Sean [mailto:Sean.ONeill_at_organon.ie]
Sent: 28 November 2000 09:46
To: Multiple recipients of list ORACLE-L
Subject: SQL functions and indexes
Last night doing some study for OCP exam I came across a note I had written in course material for PL/SQL, "SQL functions ignore table indexes and therefore can impact on performance.". So now I'm wondering if this is correct or did I take a confused message. Anyone know?
Sean :)
###### ###### ###### ###### # # # # # # # # Rookie #### # # ###### ###### Data # # # # # # # # Base # # ####### ###### # # AdminstratorOrganon (Ireland) Ltd.
-------------------------------- ------------
Visit: http://www.egroups.com/group/Oracle-OCP-DBA
The only man who never makes a mistake is the man who never does anything.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: Sean.ONeill_at_organon.ie Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Tue Nov 28 2000 - 05:57:50 CST
--------------------------------------------------------------------
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). ++++++++++++++++++++++++++++++++++++ All internet traffic to this site is automatically scanned for viruses and vandals. ++++++++++++++++++++++++++++++++++++
------_=_NextPart_001_01C05932.6E9A59A0
Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75"> <TITLE>RE: SQL functions and indexes</TITLE> </HEAD> <BODY> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: O'Neill, Sean [<A = HREF=3D"mailto:Sean.ONeill_at_organon.ie">mailto:Sean.ONeill_at_organon.ie</A>= ]</FONT> <BR><FONT SIZE=3D2>Sent: 28 November 2000 09:46</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: SQL functions and indexes</FONT> </P> <BR> <P><FONT SIZE=3D2>Last night doing some study for OCP exam I came = across a note I had written</FONT> <BR><FONT SIZE=3D2>in course material for PL/SQL, "SQL functions = ignore table indexes and</FONT> <BR><FONT SIZE=3D2>therefore can impact on performance.". So = now I'm wondering if this is</FONT> <BR><FONT SIZE=3D2>correct or did I take a confused message. = Anyone know?</FONT> </P> <P><FONT SIZE=3D2>Sean :)</FONT> </P> <P><FONT SIZE=3D2>###### ###### ###### ###### = </FONT> <BR><FONT SIZE=3D2># # = # # # # = # # Rookie</FONT> <BR><FONT SIZE=3D2>#### # = # ###### ###### Data</FONT> <BR><FONT SIZE=3D2># # = # # # # = # # Base </FONT> <BR><FONT SIZE=3D2># # ####### = ###### # # Adminstrator</FONT> <BR><FONT SIZE=3D2>-------------------------------- ------------ = </FONT> <BR><FONT SIZE=3D2>Organon (Ireland) Ltd.</FONT> <BR><FONT SIZE=3D2>E-mail: sean.oneill_at_organon.ie = [subscribed: Digest Mode]</FONT> </P> <P><FONT SIZE=3D2>Visit: <A = HREF=3D"http://www.egroups.com/group/Oracle-OCP-DBA" = TARGET=3D"_blank">http://www.egroups.com/group/Oracle-OCP-DBA</A></FONT>= </P> <P><FONT SIZE=3D2>The only man who never makes a mistake is the man who = never does anything.</FONT> <BR><FONT SIZE=3D2> - Theodore Roosevelt</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: O'Neill, Sean</FONT> <BR><FONT SIZE=3D2> INET: Sean.ONeill_at_organon.ie</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> <BR><FONT SIZE=3D2>++++++++++++++++++++++++++++++++++++</FONT> <BR><FONT SIZE=3D2>All internet traffic to this site is </FONT> <BR><FONT SIZE=3D2>automatically scanned for viruses </FONT> <BR><FONT SIZE=3D2>and vandals.</FONT>
 |
 |