on 06-01-2011 11:57 AM
Hi,
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?
Thanks,
Sri.
Hi,
You can create secondry indexes on dso, by simply draging and droping the characteristic into index folder of DSO.
Regards,
ray
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, I've now created the secondary indices - one on 0FISCPER and the other on 0FISCYEAR. Thanks a lot.
After creating the indices, I've executed the query by 0FISCPER in RSRT. I could see in the SQL Access Plan that the index on 0FISCPER has been 'Seeked' and the index on the 0FISCYEAR has been 'Scanned'.
What does 'Seek' and 'Scan' mean?
Thanks,
Sri.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.