Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Operating Systems & Databases (http://www.baanboard.com/baanboard/forumdisplay.php?f=4)
-   -   Performance refers to (http://www.baanboard.com/baanboard/showthread.php?t=69469)

richard 22nd November 2016 10:52

Performance refers to
 
Hello,
We have performance issues in ticprdll2001 (in ticpr2210), top/down.
When I replace the "refers to" by a simple equal of fields (between tcibd001 and tiipd001/tcibd200), the performance is much better.
Is there a parameter in db_resource to set?
Out db_resource is quite short:
msql_opt_rows:5
msql_array_fetch:1
msql_array_insert:1
msql_max_arrsz:5
mle_join_type:

Regards

NPRao 22nd November 2016 22:19

I don't think there is a predefined parameter to replace the "refers to" by "=".

Refer to the following threads if they help you out -

Query Performance

Oracle 10 Question Looking for Suggestions


All times are GMT +2. The time now is 23:38.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com