checking sort table as performance related one

[Former Member]

hi folks,

i am working on a report. in this im working on performance issues.

i want to check if sort table is used in the report.

i want to know the conditions where sort table IS A MUST to use for performance check purpose.

thanks in advance.

[Former Member]

Hi Michael

Sort table is recommended when you have to do READ TABLE BINARY SEARCH. You don't have to sort it in the code then.

Pushpraj

[Former Member]

Hi,

Don't use order by because it executes on database server, instead u collect them in a table and sort that table.

Regards,

jaya

[Former Member]

Hi Micheal,

You use use sort table while your using control break statements like at new or at end .

Much Regards,

Amuktha.

[Former Member]

Sort table is improve performance bcoz it has default sorting criteria. so no sorting again.

at the time of using Control Break statements. and it is use full for Binary Searching bcoz Sorting is Mandatory. And No append command is working on it.

[Former Member]

thanks alot