how to speed up odbc lookups?

Post by **admin** » Fri Nov 09, 2001 9:36 am

Hello to all.
I would like to submit a question, if you are using DataStage 4.1 and doing
a lookup to an oracle8i table, which is the most effective way to speed up
that lookup, please note that the lookup field has an index in the table,
and the table has more than 10000000 registers?
Best regards Pedro.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Post by **admin** » Fri Nov 09, 2001 12:17 pm

Hi Pedro,
If at all try to avoid doing straight lookups through either an ODBC or OCI source. You can improve the performance by loading the data into a hashed file and doing a lookup from the hashed file.

Pavan

-----Original Message-----
From: pedro santos [mailto:pedro_f_santos@hotmail.com]
Sent: Friday, November 09, 2001 3:37 AM
To: datastage-users@oliver.com
Subject: how to speed up odbc lookups?

Hello to all.
I would like to submit a question, if you are using DataStage 4.1 and doing
a lookup to an oracle8i table, which is the most effective way to speed up
that lookup, please note that the lookup field has an index in the table,
and the table has more than 10000000 registers?
Best regards Pedro.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp