Re: VB3 and Oracle ODBC SQL Pass-through - speed quirk

I'm not familiar with ODBC but consider this: In your SQL Statement
you are using column functions ( to_date(), to_char()) in the where clause of your query.
Whenever you use column functions like
 ( to_date(), to_char(), sum(), upper(), lower() etc.) oracle cannot use an index possibly defined on this columns to speed up data access.
Oracle then has to to a full table scan, which can be pretty slow.

You can find out the access path Oracle uses, by analyzing your sql-statements using
the EXPLAIN PLAN FOR ... statemement ( see your manual for details)

hope this helps,
chris