How to write efficient SQL Statement?
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?
Btw, any good book u can suggest?
Thanx!!!!!
Thenard