Do you guys see any probable issues by indexing Assignee Group -- C112 field, specifically on change tkt form. We are running our ITSM in as a single tenant option, so I do not expect our C112 field length to grow more than 256 char. So row level access should not get impacted. We have done some analysis on overview console taking longer time, seems like some of the resulting queries specifically change tkt related queries are doing table scans and we are hoping by indexing on c112, it would reduce the time to render overview console. We are on ITSM 7.6.03 with Windows 2008 and Oracle 11g.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"