Unexpected /*+ ALL_ROWS */ in Siebel SQL
Hi All,
Whenever the property "Hierarchy Parent Field" is set in the BC, then Siebel will try to maintain parent-child relationships between the records. This is achieved by triggering an extra query with the hint /*+ ALL_ROWS */.
Now in my case, the BC is "Order Entry - Orders". For this BC, we have NOT set the property "Hierarchy Parent Field". So when i navigate to Order screen, the SQL that is triggered has no hints. This is perfectly fine.
Now when I do Print --> Export to export the records in Excel, the BS: SWE Query Exporter is invoked to export the records. Now Siebel again triggers the same query but now I see the extra query with the hint /*+ ALL_ROWS */.
Whenever the property "Hierarchy Parent Field" is set in the BC, then Siebel will try to maintain parent-child relationships between the records. This is achieved by triggering an extra query with the hint /*+ ALL_ROWS */.
Now in my case, the BC is "Order Entry - Orders". For this BC, we have NOT set the property "Hierarchy Parent Field". So when i navigate to Order screen, the SQL that is triggered has no hints. This is perfectly fine.
Now when I do Print --> Export to export the records in Excel, the BS: SWE Query Exporter is invoked to export the records. Now Siebel again triggers the same query but now I see the extra query with the hint /*+ ALL_ROWS */.
0