While most of your questions have been answered by Fred and LJ I would like to further comment on the index length bit.
It is correct that a few years ago most databases would not allow you to create indexes if the fields selected to index were bigger than 255 characters. I had this exact same question about 2 or 3 years ago, when I found workflow in the ITSM that had GUIDs that were OTB set to fields with length 255. I had pointed out to BMC Support that they had these fields that were indexed that were only used to set GUID's and were 255 characters, and I thought this might be a problem. Its then that I learnt from Doug Meuller as well as BMC Support with who I had a ticket raised that the 255 characters limitation per field had long been removed by almost all databases. Most databases now have other criteria to limit the lengnt of indexes. MS-SQL for e.g goes by total length of all indexed fields on an index if I recall right. So you would need to look at what the limits on the specific database that you are working on is. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Raj Sent: Wednesday, August 21, 2013 5:26 PM To: [email protected] Subject: Adding Index to Email form on v7.6.04 ** Hi All, I am working through ARS upgrade from v5.1.2 to v8.1. Currently, on v7.6.04. After upgrading email engine I noticed that some indices were dropped on v7.6.04. We have some custom fields on AR System Email Mesages form and we had index on one of those custom fields. Now I am trying to figure out, what is the best way to add an index. Here's what I tried : Created form and view overlay of AR System Email Messages form and added index(to the overlay) in Best Practice Customization mode. But when I check for the indices by going to Base Development mode although it it there on Overlay in Best Practice Customization mode., I do not see that index. Do I also need to go to Base Development mode and add that index and save the form? I am still confused when to use Best Practice Customization Mode and when to use Base Development mode? As we will be running ARS and Email Engine upgrade from v7.6.04 to v8.1 pretty soon. Also, the index length used to be limited to 255 on v5.1.2, did that change and the limit has been increased in v.7.6.04? As I was able to add index but I got a warning message saying - "Index length longer than 255 bytes may not work on all databases: AR System Email Messages."(DB is Oracle 10g). Please advise. Thanks in advance, Raj _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
