RE: about parallel query

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 10 Jan 2001 15:57:40 -0500
Message-Id: <10737.126335@fatcity.com>

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_01C07B47.F8BBCA88
Content-Type: text/plain

Alex, are any of your tables partitioned? If they aren't, PQO may not benefit your queries and in fact may hinder them.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
From: Alex zhang [mailto:cd_toronto_at_hotmail.com] Sent: Wednesday, January 10, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Subject: about parallel query

Hi,There
We have very big table to query from. Some tables have to be joined together. It was a Internet application, so speed is so important for us. I guessed I could use parallel query to increase the query speed. But I know little about it. How can I use it? If it is possible to use parallel query and parallel server together? Thanks in advance
Alex

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Alex zhang
INET: cd_toronto_at_hotmail.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).

------_=_NextPart_001_01C07B47.F8BBCA88
Content-Type: text/html
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=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: about parallel query</TITLE>
</HEAD>
<BODY>

Alex, are any of your tables partitioned?  If = they aren't, PQO may not benefit your queries and in fact may hinder = them.

<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT>
</P>

<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>

C: 954.658.5849 <A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."

-----Original Message----- From: Alex zhang [<A = HREF=3D"mailto:cd_toronto_at_hotmail.com">mailto:cd_toronto_at_hotmail.com</A>= ]

<BR><FONT SIZE=3D2>Sent: Wednesday, January 10, 2001 3:42 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: about parallel query</FONT>
</P>
<BR>

Hi,There
   We have very big table to query from. Some = tables have to be joined

<BR><FONT SIZE=3D2>together. It was a Internet application, so speed is =
so important</FONT>
<BR><FONT SIZE=3D2>for us. I guessed I could use parallel query to =

increase the query speed. 
 But I know little about it. How can I use it? If it = is possible
 to use parallel query and parallel server = together?

<BR><FONT SIZE=3D2>Thanks in advance</FONT>
<BR><FONT SIZE=3D2>Alex</FONT>
<BR><FONT =
SIZE=3D2>_______________________________________________________________=

__________
 Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" =
TARGET=3D"_blank">http://www.hotmail.com</A>.

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Alex zhang</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: cd_toronto_at_hotmail.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 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 = Received on Wed Jan 10 2001 - 14:57:40 CST