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

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