BEX runs faster in RSRT with Oracle Hint - How to implement ?

[former_member560074]

Hi,

my BEX Query runs 10 times faster with Oracles parallel Query Hint in RSRT.

How can I implement this into the Query ?

Thanks !

Martin

[former_member219643 · Accepted solution]

Hi Martin,

I've no idea.But still I will try to explore the same.Could you please tell me where this option is present in RSRT.How did you confirm that it is 10 times faster.It's a good thing ,I wanted to explore.

Thanks

Pradeep

[former_member560074 · Accepted solution]

Hi Pradeep,

I used the parallel Query optimizer hint

in RSRT and subtransactions and the costs

seriously broke down.

Thank You

Martin

[michael_devine · Accepted solution]

Hello,

The option to include hints into the statements should only be used by DB development in order to provide a workaround for Optimizer failures.

The general approach for BW queries is not to provide access plan hints. Instead always ensure the statistics are fully up-to-date.

Regards,

Michael

[former_member560074 · Accepted solution]

Hi Michael,

the question is how to get the Hint persistent into the productive Query.

Basically, its how to get SAP/BI fast and to use

availabe resources in terms of CPU's ( which the customer has pasid and are not used)

and not what the standard does or not does.

The one makes STAR_TARNSFOMATION and nothing else which does not seem to be efficient.

You have a solution ?

ThanXs

Martin