DSO Index on 0FISCPER (Fiscal Period)
I have the General Ledger: Line Items DSO (0FIGL_O02) which at the moment has about 12 million records in Production.
As expected, the performance of the queries on this DSO is very slow. So, I would want to create Index on the DSO. The query is mainly run by '0FISCPER' (Fiscal period).
My question is, can I create index on both 0FISCPER (Fiscal Period) and also on 0FISCYEAR (Fiscal Year)?
As I already have data in the DSO, should I delete all the data, create the Index and then reload the data OR can I create the index on the fly? If I can create the Index on the fly, will it take too long to complete the job (and also create too much of transactional log files)?
Is there any other way to improve the performance of the query on this DSO?