OnDemand Users Group

Support Forums => Report Indexing => Topic started by: rstockton on September 23, 2010, 09:35:38 PM

Title: Changing Filters to Indexes
Post by: rstockton on September 23, 2010, 09:35:38 PM
I have a requirment to change 2 filters to indexes in an exisitng Application group.  There are 3 similiar application groups in the folder, but I only want to change 1 of the groups (most current data) to indexes.  Is this workable or will it affect the folder in any negative way? 
Title: Re: Changing Filters to Indexes
Post by: Justin Derrick on September 24, 2010, 02:14:14 PM
Hey Russell.

You can certainly switch on the indexes for those fields -- it will improve the performance of queries against that Application Group -- however, the results will only be as fast as your SLOWEST query.

If there is a field that your users are searching on the most, it makes sense to turn on indexing for that field to improve performance for them, and reduce CPU & IO hits for you!

Just don't go overboard!

-JD.
Title: Re: Changing Filters to Indexes
Post by: rstockton on September 24, 2010, 04:17:15 PM
Thanks Justin. 

I am assuming if we decide to change these to Indexes we should stop OD and backup DB2 before applying the changes.  Is there anything else that needs to be taken into consideration?
Title: Re: Changing Filters to Indexes
Post by: Justin Derrick on September 24, 2010, 09:46:15 PM
A fresh backup is *always* a good idea.

Just remember that creating indexes from scratch, especially when you have a LOT of documents, will take a considerable amount of time.  You'll want to do this when the system is idle.

To get an idea of how long it might take (and how much disk space you'll use) it would be best if you did a test on a smaller App Group first.

Good luck!

-JD.