Re: Performance of ODBC vs. other access methods

[richard@xxxxxxxxxxx]

Steve, are you alluding that other databases are smart enough to create 
their own permanent indexes and views based on what the DB thinks the 
access path should be ?

If so, that's very cool.  Show me where I can get some of that :-)

Regards,
Richard Schoen
RJS Software Systems Inc. 
"Providing Your....iNFORMATION NOW!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
------------------------------

message: 2
date: Wed, 6 Sep 2006 14:11:23 -0400
from: "Steve Richter" <stephenrichter@xxxxxxxxx>
subject: Re: Performance of ODBC vs. other access methods

On 9/6/06, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:
> Steve - this comment of Richard's is about vendor updates, not 
persistent and continual maintenance and administration - i fear your 
comments do not address the point made.

ok, sorry.  I still think it is nuts that db2 cant keep track of what
indexes should and should not be retained and maintained based on
their frequency of use and the time it takes to build them.   If the
system was not geared down it would have the horsepower needed to
perform this task.

-Steve