RE: Indexing an SQL view

["Erhardt, Bill" <Bill.Erhardt@xxxxxxxxx>]

Just a comment.  IBM has told me that an SQL Index retrieves data using a
16MB access but logical files use a 4MB access.  I'm not sure about the term
"ACCESS" but I created a number of suggested views (from the V5R2 SQL
Optimizer) and was able to see a better then 10 fold increase in performance
(as measured in reduced response time).
Bill Erhardt

-----Original Message-----
From: Rick.Chevalier@xxxxxxxxxxxxxxx [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx]

Sent: Monday, April 19, 2004 3:38 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Indexing an SQL view


The creation of a DDS logical over the physical file with the substring
values as keys seems to have done the trick.

A lot of panic ensues here whenever triggers are mentioned so I don't think
Walden's suggestion would get far.  Maybe we'll get indexed views soon.

Thanks for all the help,

Rick

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

-----------------------------------------
This message was scanned for viruses.