Need more info about prompt in WIASP & improving execution time

[viny]

Hi all,

Do anyone will give me a answer to these questions?

1.Can we run prompt in WIASP(We have trial version of BO kits with us) if
so How can I use it?
2.Is it possible to improve the speed of query running time? as it takes
long, some time not running at all the queries we are running.

 

[jimbopalmer]

2. If you are using Oracle as the backend database, you can embed oracle hints in the object definitions, so

/*+ all_rows */ par_part as a definition will get built as

select /*+ all_rows */ par_part, par_desc.....

this allows you to give the Oracle Database hints how you want the SQL parsed, even though the users are not technically profiencent .

Hope that helps. The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold