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"

Reply via email to