Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Mon, Mar 18 2013 12:55 PM	Permanent Link
Barry	I have GUID columns in some of my tables and I'm wondering is there any point in having them declared as Case Insensitive? Will table joins and lookups be faster if they are declared as Case Sensitive? TIA Barry
Mon, Mar 18 2013 1:12 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Barry, << I have GUID columns in some of my tables and I'm wondering is there any point in having them declared as Case Insensitive? Will table joins and lookups be faster if they are declared as Case Sensitive? >> Probably not. For the ANSI/UNI collations, case-insensitive searches are slightly slower due to the additional case considerations done during comparisons. Tim Young Elevate Software www.elevatesoft.com