Skip to Content
1
Apr 30, 2012 at 07:40 AM

Secondary index for Performance

699 Views

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.

Thanks

Dev