RE: Performance of ODBC vs. other access methods

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

Due to the fact that there are no indexes or access paths that do NOT
use that particular field as the primary key, an access path is built
every stinking time...building an access path takes much more cycles,
etc than using an existing access path especially when millions of rows
are involved.  For example, I can run a query minus the (useless)
primary key field over the audit file the query takes 15 mins to
complete (with 4 million rows) I can add the semi-useless primary field
to the query & it runs under a minute...(IMO that's an exponential
impact!!!) 


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, September 06, 2006 9:38 AM
To: Midrange Systems Technical Discussion
Subject: RE: Performance of ODBC vs. other access methods

Interesting.  So, what makes you think that this has an exponential
impact 
on performance?

Rob Berendt