We need to do extracts from GLPCA by an external connector (Qlickview) on a regular basis (daily or weekly) but we dont have any good indexes to use. Currently we are searching using fields RLDNR, RRCTY, RVERS, RYEAR, RBUKRS and perhaps POPER.
Would it be a good idea to put an index on CPUDT and CPUTM (creation date and time) to be able to extract data based on that info? How will performance be affected in the applications by adding another index?
We have 113 million rows and are adding approx 5 M per month. Will it take forever to create the new index?
Can I perhaps build the index "behind" SAP, ie directly in the database somehow?
Any other suggestion?