Drake, Thanks..
I have sent you an email with the query. The query was written for MS-SQL so you might need to alter it appropriately if you are on oracle as I do use a type casting function CHAR which I think is TOCHAR in Oracle.. Any others willing to poke around this so we could discuss our findings, feel free to raise your hands.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Drake, David Sent: Thursday, April 22, 2010 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: Indexing violations in the Remedy database.. ** /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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
