/raise hand ________________________________
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, April 21, 2010 4:48 PM To: arslist@ARSLIST.ORG Subject: Indexing violations in the Remedy database.. ** I need to collaborate with some of you SQL pro's out here to work with me to fetch a list of forms that may have indexes defined in Remedy that may violate a very basic rule in most standard RDBMS's. Indexes in most RDBMS's (Oracle, MS-SQL, Informix etc) that a Remedy server might be using, need to have indexed fields of less than 255 characters in length to the best of my knowledge. First of all I want to CONFIRM that this rule is true for all RDBMS's.. If it is true, then I ran a query to find any fields that may be indexed and violating this basic rule.. I can share this query with you if you want to join me on a collaborated effort to list all schemas that have fields that are indexed that may indeed be greater than 254 characters. Any volunteers? I have a ready query I can share with you.. Joe _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"