How does Informix evaluate the = in a join or slect

This is a multi-part message in MIME format. --------------4E6431321844 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit -- __ _/ __ Albert Wisse \\ \\\\// / Cayenne Software Customer Services \\ \\/ / Olof Palmestraat 24 wissea@cayennesoft.nl C A \\ / E N N E 2600 GB Delft (+31) 15 21 519 10/19 / / the Netherlands (+31) 15 212 0267 (Fax) /_/ http://www.cayennesoft.com Cayenne Software is a Bachman and Cadre company --------------4E6431321844 Content-Type: text/plain; charset=us-ascii; name="informix.txt" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="informix.txt" I have the following question about how Informix evaluate the "=" I have tables with a few thousand rows. The key on which is selected or joined has datatype varchar[64]. The key consist of two parts first a less unique part and then an unique part, Id='<less unique part>:<unique part>' . The less unique part is for about 1% unique and the unique part for 100%. Example: key='aaaaaaaaaaaa:1234567890' key='aaaaaaaaaaaa:2345678901' I f I do a select like "select * from A where A.key = 'aaaaaaaaaaaa:1234567890'" how evaluate Informix the "=", start it at the first word or from the last one. Make a difference if the select contains a join like "select * from A, B where A.key = B.key Make it sense to swap the parts in '1234567890 aaaaaaaaaaaa' --------------4E6431321844--