1. Home
  2. Support
Article - CS104854

Some queries use the /*+ RULE */ hint in Windchill

Modified: 29-Mar-2024   


Applies To

  • Windchill PDMLink 10.0 M010 to M040
  • Windchill PDMLink 10.2 M030-CPS15

Description

  • Some queries use the /*+ RULE */ hint, leading to use the Rule Based Optimizer instead of the Cost Based Optimizer in Oracle
  • The queries identified are on RecentUpdate, QueueEntry and ScheduleQueueEntry tables, for example:
SELECT /*+ RULE */
'wt.recent.RecentUpdate',
A0.businessObjectRef,
A0.listKeyName,
A0.name,
A0.ownerRefIsNull,
A0.classnamekeyA4,
A0.idA3A4,
A0.classnamekeyB4,
A0.idA3B4,
TO_CHAR (A0.createStampA2, 'dd mm yyyy hh24:mi:ss'),
A0.markForDeleteA2,
TO_CHAR (A0.modifyStampA2, 'dd mm yyyy hh24:mi:ss'),
A0.idA2A2,
A0.updateCountA2,
TO_CHAR (A0.updateStampA2, 'dd mm yyyy hh24:mi:ss')
FROM RecentUpdate A0
WHERE ( (A0.idA3A4 = :1)
AND (A0.listKeyName = :2)
AND (A0.businessObjectRef = :3)) FOR UPDATE
This is a printer-friendly version of Article 104854 and may be out of date. For the latest version click CS104854