Randy:
If I had a table with 1 row, 11 columns per item of data, then
there would be one indexed integer column (let's say Column1).
I would only retrieve using this type of query:
select Column8 from table where COLUMN1 = <whatever>
If instead I had a table with 3 columns, 10 rows per item of
data, then there would be two indexed integer columns (Column1
as above, and Column2):
select Column3 from table where COLUMN1 = <whatever> and
COLUMN2 = <whatever>
In all cases, I am only interested in grabbing ONE piece of
data at a time. This is a lookup table only, probably only
done as a report variable.
Karen
> Without knowing, I assume there is an indexed or
>Primary Keyed row which is used to identify what you are
>looking for. I also presume (without knowing) that the
>database will travel 1 million indexed rows in a 3 column
>table at the same speed as 1 million indexed rows in an 11
>column table. [Please correct me if that is erroneous.
>Would it be true for a non-indexed table?]
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
