title: AS/400 query response time
body: <p>What I'm doing....</p>
  
  <p>I am connecting to an AS400 via ODBC (currently I have to use ODBC) in a C#/.Net application. 
  The queries are dog slow.  I run DBmonitor &amp; query the file that it returns where QQIDXA = 'Y' and I'm being told to create indexes, that already exist.  The reason codes are I1 &amp; I3.  </p>
  
  <p>I have rebuilt the indexes, in the same order that the where clauses are, with no luck.</p>
  
  <p>What can I do to improve my AS400 queries???</p>
  
  <p>AHIA,
  LarryR...</p>