What are your data volumes here, and what is the business need to convert to discrete? In general, it's not a good idea to convert unless the data volumes generated by the conversion are very low. It may create a data set that's easier to report from, but at the expense of massive tables and indexes and a much busier database.
If it does not help you to resolve the problem (statistics gathering can help if it is not collected regularly), feel free to open a support incident and share your findings including the ME SQL trace.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.