Start a new topic

Improving database query performance

When running QuickQueries against a large (typically, several millions of events) database, performance can be improved by adding database indices against the slots that are most often queried in ProactivePack.


To create an index (example given for a oracle database and for a custom slot "my_environment"), the command is simple.


 

sqlplus BMC_PAP@DB_PPACK.proactivepack.com
>create index BMC_PAP_environment on EVENT_REP_MAIN(my_environment);

 




To identify which slots are most frequently used in QuickQueries Advanced Conditions (assuming linux) :


  

cd $PRODUCT_HOME/data/QuickQueries/queries
grep SlotName query* | cut -d = -f 2 |sort | uniq -c

  



Login or Signup to post a comment