E-QR: Summary for some of the Query best practices (Doc ID 656110.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.2 and later
Information in this document applies to any platform.
SPECIFIC TO:
Enterprise, PeopleTools, Query Manager


Symptoms


Poorly written SQL is causing Cartesian Joins and full Table scans. What are some of the Query best practices that would help avoid this?


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms