From: Alex K. <al_...@ya...> - 2005-04-07 10:58:42
|
Hi! It will be nice to see in future versions of Firebird the following things: 1) Better support of aliases in queries For example the following query produces error but perfectly legal from my point of view: select employeeid, sum( amount ) as income from payouts group by employeeid having income > 10000; 2) Indexes should be used for unstrict search conditions For example index is _used_ during execution of query below: select recid from mytable where status = 0; but NOT used during execution of the following query (even if valid plan was specified); select recid from mytable where status < 1; SY, Alex Kotov |