New tip on OMNIbus ObjectServer SQL best practice
Zhenni 06000209QP Comments (2) Visits (8036)
Recently we have found out the following simple SQL condition performs much better than its regular expression equivalent.
Summary LIKE 'NETCOOL|netcool'(The column name "Summary" above could be any VARCHAR field in the ObjectServer )
The performance difference is significant for a production ObjectServer where there are more than 30K alerts in alerts.status table and very long strings in Summary or other VARCHAR fields.
When we create the filter for Event List or AEL, we'd better avoid the bad SQL condition above.