Solved

How can I see the IAL query? ?

  • 17 February 2022
  • 2 replies
  • 476 views

Userlevel 3
Badge +9

Hi,

I have two questions,

my first question,How can I see the query of the created IAL object?

My second question is that the created IAL object is slow to fetch the data to the lobby. How can I speed this up?

 

Best regards,

Mervan 

 

 

 

icon

Best answer by Nagah.khaled 17 February 2022, 09:00

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +13

to know the source of IAL Object:

use the command desc in your database editor.

in you use toad:

write the object name and press F4, and read the script tab.

 

to speed up the report:

use sorted fields  to build the relation between objects of the query and conditions.

primary key, foreign key, etc.

 

 

 

Userlevel 3
Badge +9

thank you @Nagah.khaled 

best regards

mervan