I did not remove the indexes. I assumed removing the "uneeded" indexes would be better for the database. We are not seeing problems at this point but trying to be proactive. The bulk of reports in our old Remedy system used create and resolved dates
I was trying to figure why the indexes exist and if some of them could be removed. The indexes I want to add are on datetime fields such as submit date and resolved date. Not sure why these are not indexed OOTB as they are used for the most basic ticket metrics. FTS will not work on date fields. Also, for users doing reporting via direct DB access (not through ARS) how is FTS going to help them? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
