firebird-support - Re: [firebird-support] Hierarchical SQL Query

Subject	Re: [firebird-support] Hierarchical SQL Query
Author
Post date	2017-06-14T05:48:25Z

Hi Michał Kurczabiński

Actually i missed to create the indices for the search columns and linking columns, Now after creating the indices on those columns the "Total execution time is 0.537s". instead of almost 4s.

Created indices On :

TBLTRANSMAST - > REFSGUID

TBLTRANSMAST - > LEDGERMASTID

TBLLEDGERMAST -> LINKLEDGERGROUPID

TBLLEDGERMAST -> LEDGERNAME

TBLLEDGERGROUP -> LINKLEDGERGROUPID

Thanks a lot Mr. Michał Kurczabiński for guidance.