PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Performance problem with LF having Select and Omitt Levels

View previous topic View next topic Go down

Performance problem with LF having Select and Omitt Levels

Post  maran on Thu Jan 10, 2013 1:15 am

Performance problem with LF having Select and Omitt Levels

Most shops that are moving from record level access (RLA) to SQL data access still have logical files built using DDS that have select/omit logic

The problem:
This is a problem that the SQL Query Engine (SQE) cannot process SOL logical files by design and forces the SQL to be executed by the Classic Query engine (CQE).

How to override this problem:
This can be averted by changing the QAQQINI file so that SOL logical files are ignored. To do this, change the value of IGNORE_DERIVED_INDEXES to *YES. This is going to vastly improve our overall SQL performance considerably.

maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum