Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Advice for embedded queries
Summary
Advice for embedded queries
Content
We currently use BIP 11.1.1.7, and have several large reports, some of which make use of embedded queries. When running a render job, our global ID predicate can sometimes include a larger set than we need for an individual burst, to improve performance we make use of a reference link in the embedded queries (same format that BIP generated to link different groups, IE: :G_1.RENDER_SET_ID)
This has been working well for us, allowing our largest render set to go from never completing to completing in a very desirable time frame. My problem is that BIP 12 does not seem to like these reference links. Has BIP 12 improved predicate pushing such that it would no longer be necessary to do this, or is there another way of achieving this type of cross linking?