Report with oracle databas in T24

Dear all,

could you please guide me, after our system convert from jbase to oracle, all report enquiries so slow produce data. How could i do? Please guide way to improve those code.

Thank so much.

There are many ways to improve performance

1) use index on filtering colums (but recommended indexes are 4)
2) use of concat files of accessing data from large volume files
3) a proper mechanism to purge data from bulk files

From oracle side you can create VIEW and use that for enquiries.

From T24 side it's tough to generate reports while using oracle. You can extract the data from Oracle T24 tables, normalise it and from that you can generate reports of your requirement.

yes, for create index we create already and some report when we use SSELECT or number of record for loop is many, The report will be dead. Any way more on it?