Re: How to write efficient SQL Statement?

In article <34edbd07.3196399@news.netvigator.com>, '''' Thenardier <Thenardier@POBoxes.com> writes > >Hi, > >I'm new to Informix. But now i'm ask to develop a system on >an Informix platform as backend and PowerBuilder 5.0 as frontend. >I wonder how Informix interpret SQL statements. Say in a SQL >statement like: > >SELECT id, name FROM tableA >WHERE criteriaA = 'XXX' AND > criteriaB = 'YYY' AND > criteriaC = 'CCC';> >What would Informix do to this? Reading criteriaC >first then go up, or from up to down? Can anyone tell? > It does not go in any direction but determines what indexes exist and how unique the index keys are... >Btw, any good book u can suggest? > >Thanx!!!!! > > >Thenard -- 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