Re: Index Advisor - Column does no exists on table...

Jerry,

Thanks for your answer.

No, this table has not any field with a name bigger than ten characters. A
point I hadnt' comment about is that, if I ask the Index advisor to create
the index, it drops the *SUBQJ0001 field.


Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, Apr 12, 2010 at 11:18 AM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:

Is this the 10 character or less field name given to an SQL DDL field that
exceeds 10 characters?

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Monday, April 12, 2010 10:36 AM
To: Midrange Systems Technical Discussion
Subject: Index Advisor - Column does no exists on table...

Hi all,



I was checking a SQL sentence with Visual Explain and the Index Advisor
suggested an index with two columns, the first one being *SUBQJ0001 (The
second column already exists as an index)



Does anyone have an idea what this refers to?



Thanks in advance,


Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--
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 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.