<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:ns0 =
"http://www.exclaimer.co.uk"><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=265175618-11082005><FONT face=Arial color=#0000ff size=2>Oops,
didn't read enough. What I said is valid but doesn't apply in this case. Joe is
right in that QUIZ will see the linkage as repeating, which it is. I
suggest that using a cursor will save time.</FONT></SPAN></DIV>
<DIV><SPAN class=265175618-11082005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=265175618-11082005><FONT face=Arial color=#0000ff
size=2>Bob</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Joe Boyle
[mailto:atla38@dsl.pipex.com] <BR><B>Sent:</B> August 11, 2005 2:52
PM<BR><B>To:</B> Deskin, Bob; fernando.olmos@hpa.com.au;
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Indexed or
Seq?<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">the index in question
is made up of nine segments, surely all B rows will be returned where there is
a 1<SUP>st</SUP> segment match with the A row 1<SUP>st</SUP> segment
?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">e.g. would not the
code below return all B rows with value “literal” in seg1
<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">access A link seg1 to
seg1 of B<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">choose seg1
“literal”<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">rep
all<o:p></o:p></SPAN></FONT></P>
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,
Joe.</SPAN></FONT><FONT color=navy><SPAN style="COLOR: navy">
<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=3>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Deskin, Bob<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> 11 August 2005 14:06<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> fernando.olmos@hpa.com.au;
powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Indexed or
Seq?</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">There are two issues
here. First is how QUIZ deals with UNIQUE indexes and second the fact that
this is relational.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">When linking to a
UNIQUE index, QUIZ assumes that there is only one record/row to retrieve. So
in the statement </SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">ACCESS A LINK TO
B</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">where B is retrieved
via a unique index, for each A, QUIZ will attempt to retrieve only one B
record/row. And of course it is the first such record/row that you see in your
record complex.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Now on to relational.
While QUIZ knows that the index is unique from the database schema, it
retrieves the data as if it was an indexed file as opposed to generating a
SELECT with a JOIN. As well, the individual SELECTs are passed to the database
and it is the database that determines how to retrieve the data and which row
to return. If you specify VIAINDEX in the linkage, we'll pass down an ORDERBY
so that you get the first row in the index, however that would only be
meaningful with a repeating index and not in this case (sorry for the brief
tangent).</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">It is well known that
using cursors is typically more efficient that straight linkage. In this case
I suggest you do a performance comparison between the ACCESS statement that
you have and a DECLARE CURSOR using the appropriate
JOIN.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Bob</SPAN></FONT><o:p></o:p></P></DIV>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0cm">
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face=Tahoma
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of
</SPAN></B>fernando.olmos@hpa.com.au<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> August 10, 2005 7:49
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> Indexed or
Seq?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><!-- Converted from text/rtf format -->Hi
everyone,</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I've been given the task of
speeding up record complexes for a master/detail set of tables, where the
detail table</SPAN></FONT> <FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">has</SPAN></FONT> <FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">over 3
million records. Don't worry, I am not going to ask the obvious, but I was
wondering if someone can help me determine how QUIZ looks</SPAN></FONT>
<FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">up</SPAN></FONT> <FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">data for
where one the lookup field is the first field in the UNIQUE index
set.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Here are the QSHOWs for the two
tables in question ...</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Record:
INVOICED_DETAIL</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> of
Database: #####</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Organization: RELATIONAL</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> Null
Values Allowed:No</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Type:
ORACLE</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> Hold
Cursor: Unspecified</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Open:
#####</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Record Size: 558
Bytes</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">-- Record Contents
--</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Item
Type
Size Occ Offset</SPAN></FONT> <BR><FONT face="Courier New"
size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
ORDER_NO
INTEGER SIGNED
8
0</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PRIMARY_ID
CHARACTER
2
8</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
SECONDARY_ID
CHARACTER
2
10</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PROD_LVL0
CHARACTER
2
12</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PROD_LVL1
CHARACTER
2
14</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PROD_LVL2
CHARACTER
2
16</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PROD_LVL3
CHARACTER
2
18</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PROD_LVL4
CHARACTER
2
20</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
PRODUCT_CODE
VARCHAR
16
22</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
EVENT_ID
INTEGER SIGNED
4
38</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">..</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">etc</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">..</SPAN></FONT>
<o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">-- Index Contents
--</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> ** ORDER_KEY_ID
is a UNIQUE index **</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Segment
Type
Size Ord Offset</SPAN></FONT> <BR><FONT face="Courier New"
size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
ORDER_NO
INTEGER SIGNED 8
A 0</SPAN></FONT> <BR><FONT
face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PRIMARY_ID
CHARACTER
2 A 8</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
SECONDARY_ID
CHARACTER
2 A 10</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PROD_LVL0
CHARACTER
2 A 12</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PROD_LVL1
CHARACTER
2 A 14</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PROD_LVL2
CHARACTER
2 A 16</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PROD_LVL3
CHARACTER
2 A 18</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PROD_LVL4
CHARACTER
2 A 20</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
EVENT_ID
INTEGER SIGNED 4
A 22</SPAN></FONT> <BR><FONT
face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
PRODUCT_SEQ_NO
INTEGER SIGNED 4
A 26</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Other indexes are all REPEATING
and do not reference any of the above indexes</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Record:
INVOICED_MASTER</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> of
Database: #####</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Organization: RELATIONAL</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> Null
Values Allowed:No</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Type:
ORACLE</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> Hold
Cursor: Unspecified</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Open:
#####</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Record Size: 591
Bytes</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">-- Record Contents
--</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Item
Type
Size Occ Offset</SPAN></FONT> <BR><FONT face="Courier New"
size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">r
ORDER_NO
INTEGER SIGNED
8
0</SPAN></FONT> <BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">..</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">etc</SPAN></FONT>
<BR><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">..</SPAN></FONT>
<o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">-- Index Contents
--</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'"> ** ORDER_NO_IM is
a UNIQUE index **</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
Segment
Type
Size Ord Offset</SPAN></FONT> <BR><FONT face="Courier New"
size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">
ORDER_NO
INTEGER SIGNED 8
A 0</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Again, there are other repeating
indexes, but they are not relevant to my query.</SPAN></FONT>
<o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">If I link the two tables using a
simple direct link, like the following ...</SPAN></FONT> <o:p></o:p></P>
<P><FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">access invoiced_master
in hisdb &</SPAN></FONT> <BR>
<FONT face="Courier New" size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Courier New'">link order_no to
order_no of invoiced_detail in hisdb</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Will QUIZ use the UNIQUE index
defined in INVOICED_DETAIL to look its records directly, or because the
ORDER_NO column is not<B><SPAN style="FONT-WEIGHT: bold">
explicitly</SPAN></B> defined as a primary key (not unique of course), will
it use sequential searching?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I hope I made myself clear here.
If not please ask.</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">PS: this email contains rich
text formatting. Please forgive me if it appears in your mailbox all over
the place!</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks guys.</SPAN></FONT>
<o:p></o:p></P></BLOCKQUOTE></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">This
message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you may
not use, copy, disseminate or distribute it; do not open any attachments,
delete it immediately from your system and notify the sender promptly by
e-mail that you have done so. Thank you.</SPAN></FONT>
<o:p></o:p></P></DIV>
<DIV>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
</SPAN></FONT><o:p></o:p></P></DIV></DIV></BLOCKQUOTE></BODY></HTML>