Good morning,
We created a new view for a search help. This view is between a header table (DFKKKO) and Items (DFKKOP) where 99.9% of the records have a 1 to 1 relationship between the tables. The fields in the view either exist in the main index or secondary indices of the joined tables.
When we do the searches on the main tables, we get results quite fast, but we're now experiencing timeouts on the view searches which only leads me to believe it is not using the secondary indices.
Any idea what we can do additionally? We're thinking of just creating two separate search helps for each table, but the users are not happy with that solution.
Thanks
Thys