RE: how to know what kind of index

System i Navigator/Databases/<yourSystem>.right click.index advisor ?

________________________________________
From: midrange-l-bounces@xxxxxxxxxxxx [midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of ankush agrawal [aankush39@xxxxxxxxx]
Sent: Wednesday, November 30, 2011 13:16
To: Midrange Systems Technical Discussion
Subject: how to know what kind of index

Hi All,

One of my friend is working on the performance for some reports in insight
software. Extracted the query it runs and trying to run using the WinSQL .

While running the query , system is trying to build runtime index. How do i
know what kind of index it is trying to build?



Thanks,
--
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.