×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
When we bought DB2 Web Query, I was fortunate enough to work with Doug Mack and Jim Bainbridge. They gave me a crash course using System i Navigator... what an awesome experience. They taught me a lot.
But like most things, you either use it or lose it. And now the interface has changed as well.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Buck Calabro
Sent: Monday, August 21, 2023 2:01 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: RE: DB2 Views issue
On 8/21/2023 1:17 PM, Greg Wilburn wrote:
I'm not sure how to find the "most expensive" in VE. I'm pretty sure the last time I used index advisor it was in client access.
View > Highlighting > Expensive Icons
I've tried to wring value out of Visual Explain, but I haven't had any
luck. All of the indexes it would advise have long since been created.
The times I think I need VE are for those behemoths - a view over other
views. It highlights a Table Scan, but tells me that it chose the scan
because the cost was less.
I'd love a decent tutorial with examples.
midrange.com
