jbase select
- Andi
- Topic Author
- Visitor
-
10 years 3 weeks ago #17574
by Andi
jbase select was created by Andi
Dear JPB thank you for your suggestion
and i have another issues which is related with the tuning
To execute the following query it take more time . is there a method to solve this problem( to minimize the time taken during the execution)
jsh t24test ~ -->SQLSELECT a.ACCOUNT_TITLE_1, a.ACCOUNT_NUMBER, a.OPEN_ACTUAL_BAL, a.WORKING_BALANCE, b. AMOUNT_LCY FROM FBNK.ACCOUNT a, FBNK."STMT.ENTRY" b WHERE a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER AND a.CATEGORY = '6602’
and i have another issues which is related with the tuning
To execute the following query it take more time . is there a method to solve this problem( to minimize the time taken during the execution)
jsh t24test ~ -->SQLSELECT a.ACCOUNT_TITLE_1, a.ACCOUNT_NUMBER, a.OPEN_ACTUAL_BAL, a.WORKING_BALANCE, b. AMOUNT_LCY FROM FBNK.ACCOUNT a, FBNK."STMT.ENTRY" b WHERE a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER AND a.CATEGORY = '6602’
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
10 years 3 weeks ago #17575
by jpb
Replied by jpb on topic jbase select
I don't use SQLSELECT that much, I'm a fan of native JQL ;-)
But i fear there is not much you can do to speed up the statement as queries on STMT.ENTRY always take long due to the (normally) big amount of data. If you integrate a sort it will take ages.
Try other ways to get your desired result, e.g. two separate queries and combine them in a spreadsheet.
But i fear there is not much you can do to speed up the statement as queries on STMT.ENTRY always take long due to the (normally) big amount of data. If you integrate a sort it will take ages.
Try other ways to get your desired result, e.g. two separate queries and combine them in a spreadsheet.
Please Log in or Create an account to join the conversation.
Time to create page: 0.028 seconds