Re: How does Informix evaluate the = in a join or slect

In article <34DAD453.605B@cayennesoft.com>, Albert Wisse <wissea@cayennesoft.com> writes >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' It should make little difference since Informix treates the whole columnas the index key. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care