Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Query Optimizer - logical file select/omit

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Query Optimizer - logical file select/omit

    See response to SELECT SQL - Use of a Logical Use SQL to define indexes (probably better performance) and avoid use of Select/Omit logicals. There is not enough information given to give you a good answer. The Value "X" is probably not unique enough to narrow the data down.

  • #2
    Query Optimizer - logical file select/omit

    Why won't the Query Optimizer use an existing logical file that has keys and select/omit criteria that match an SQL Select statement? Viewing the debug messages seems to point to the select/omit as the problem. Can the Where clause be changed so the Optimizer will be "influenced" to use the logical file. The statement "select * from fileA where status<>'X' order by key1" won't use logical file fileA1 that has the following DDS definition. A R FORMATA PFILE(FILEA) A K KEY1 A S STATUS COMP(NE 'X')

    Comment


    • #3
      Query Optimizer - logical file select/omit

      Thanks for your responses to my questions. The select/omit is not unique enough in our data so that sounds like the problem.

      Comment

      Working...
      X