db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Trivial Update of "TuningTenTwo" by LauraStewart
Date Mon, 09 Oct 2006 22:10:07 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by LauraStewart:
http://wiki.apache.org/db-derby/TuningTenTwo

------------------------------------------------------------------------------
  [[Anchor(internallanguage)]]''' Internal language transformations :'''
  
  ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- ||Unknown parameter || http://db.apache.org/derby/docs/dev/tuning/rtuntransform472.html
|| Rajesh|| There is a mention of rewriting queries - "Users can work around this possibility
by writing the query like this (which is not optimizable):(country... '') LIKE ?". But this
does not mention the rationale for doing so, which could be benefical for the users in understanding
the transformation.  || ||
+ ||Unknown parameter || http://db.apache.org/derby/docs/dev/tuning/rtuntransform472.html
|| Rajesh|| There is a mention of rewriting queries - "Users can work around this possibility
by writing the query like this (which is not optimizable):(country... '') LIKE ?". But this
does not mention the rationale for doing so, which could be benefical for the users in understanding
the transformation.  || Derby-1946 opened to address this issue https://issues.apache.org/jira/browse/DERBY-1946
||
  ||Predicates pushed into views or derived tables  || http://db.apache.org/derby/docs/dev/tuning/ctuntransform36623.html
|| Rajesh|| Typo   - "Pushing down means that the qualification described by the predicate
can be evaluation..." should be "Pushing down means that the qualification described by the
predicate can be evaluated..."  || Patch submitted (Laura) ||
  ||Predicates pushed into views or derived tables  || http://db.apache.org/derby/docs/dev/tuning/ctuntransform36623.html
|| Rajesh|| Query   - "SELECT a, b FROM (SELECT sales_person, MAX(sales) from Sales WHERE
city_id = 2 GROUP BY city_id) v1(a, b)" does not seem correct, I think the correct one is
"SELECT a, b FROM (SELECT sales_person, MAX(sales) from Sales WHERE sales_person = 'LUCCHESSI'
GROUP BY sales_person) v1(a, b)" || Patch submitted (Laura) ||
  

Mime
View raw message