Is there any restrictions or side effects on creating a secondary index on a date field ?.
Many of the reports use date in the selection criteria while searching on VBRK/VBRP or MKPF/MSEG tables. The execution takes long time as the data grows.
Is it recommened to create an index on date filed to improve the performance? say VBRK-FKDAT.