|
Size: 3836
Comment:
|
← Revision 12 as of 2009-09-20 22:12:04 ⇥
Size: 3856
Comment: converted to 1.6 markup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| This page is for reviewing the 10.2 [http://db.apache.org/derby/manuals/index.html#latest ''Derby Tuning Guide'']. | This page is for reviewing the 10.2 [[http://db.apache.org/derby/manuals/index.html#latest|''Derby Tuning Guide'']]. |
| Line 3: | Line 3: |
| ''This page just has initial Section Summary and Sub Section Details set up. The [http://wiki.apache.org/db-derby/GettingStartedTenTwo/ReferenceManualTenTwo Reference Manual] has a complete review setup.'' | ''This page just has initial Section Summary and Sub Section Details set up. The [[http://wiki.apache.org/db-derby/GettingStartedTenTwo/ReferenceManualTenTwo|Reference Manual]] has a complete review setup.'' |
| Line 9: | Line 9: |
| ||[#workingwithderbyprop Working with Derby properties] || || || ||[#perftickstips Performance tips and tricks] || || || ||[#tunederbyandapps Tuning databases and applications] || || || ||[#dmlstmt DML statements and performance] || || || ||[#selectivity Selectivity and cardinality statistics] || Rajesh || Complete || ||[#derbyprop Derby properties] || Rajesh ||Complete || ||[#internallanguage Internal language transformations] || Rajesh || In Progress || |
||[[#workingwithderbyprop|Working with Derby properties]] || || || ||[[#perftickstips|Performance tips and tricks]] || || || ||[[#tunederbyandapps|Tuning databases and applications]] || || || ||[[#dmlstmt|DML statements and performance]] || || || ||[[#selectivity|Selectivity and cardinality statistics]] || Rajesh || Complete || ||[[#derbyprop|Derby properties]] || Rajesh ||Complete || ||[[#internallanguage|Internal language transformations]] || Rajesh || In Progress || |
| Line 18: | Line 18: |
| As you spot issues please add specific comments to the tables below, paying attention to the [http://wiki.apache.org/db-derby/TenTwoDocReview guidelines]. For very extensive comments, please post to derby-dev or Jira instead, then include the URL in the Comment field. | As you spot issues please add specific comments to the tables below, paying attention to the [[http://wiki.apache.org/db-derby/TenTwoDocReview|guidelines]]. For very extensive comments, please post to derby-dev or Jira instead, then include the URL in the Comment field. |
| Line 20: | Line 20: |
| [[Anchor(workingwithderbyprop)]]''' Working with Derby properties :''' | <<Anchor(workingwithderbyprop)>>''' Working with Derby properties :''' |
| Line 24: | Line 24: |
| [[Anchor(perftickstips)]]''' Performance tips and tricks :''' | <<Anchor(perftickstips)>>''' Performance tips and tricks :''' |
| Line 28: | Line 28: |
| [[Anchor(tunederbyandapps)]]''' Tuning databases and applications :''' | <<Anchor(tunederbyandapps)>>''' Tuning databases and applications :''' |
| Line 32: | Line 32: |
| [[Anchor(dmlstmt)]]''' DML statements and performance :''' | <<Anchor(dmlstmt)>>''' DML statements and performance :''' |
| Line 36: | Line 36: |
| [[Anchor(selectivity)]]''' Selectivity and cardinality statistics :''' | <<Anchor(selectivity)>>''' Selectivity and cardinality statistics :''' |
| Line 40: | Line 40: |
| [[Anchor(derbyprop)]]''' Derby properties :''' | <<Anchor(derbyprop)>>''' Derby properties :''' |
| Line 44: | Line 44: |
| [[Anchor(internallanguage)]]''' Internal language transformations :''' | <<Anchor(internallanguage)>>''' Internal language transformations :''' |
This page is for reviewing the 10.2 ''Derby Tuning Guide''.
This page just has initial Section Summary and Sub Section Details set up. The Reference Manual has a complete review setup.
Section Summary
Please list the sections you intend to review in the summary table below:
Section Name |
Reviewers |
Status |
|
|
|
|
|
|
|
|
|
|
|
|
Rajesh |
Complete |
|
Rajesh |
Complete |
|
Rajesh |
In Progress |
Sub Section Details
As you spot issues please add specific comments to the tables below, paying attention to the guidelines. For very extensive comments, please post to derby-dev or Jira instead, then include the URL in the Comment field.
Working with Derby properties :
Sub Section |
HTML Url or PDF Page |
Reviewer |
Comment |
Resolution |
Performance tips and tricks :
Sub Section |
HTML Url or PDF Page |
Reviewer |
Comment |
Resolution |
Tuning databases and applications :
Sub Section |
HTML Url or PDF Page |
Reviewer |
Comment |
Resolution |
DML statements and performance :
Sub Section |
HTML Url or PDF Page |
Reviewer |
Comment |
Resolution |
Selectivity and cardinality statistics :
Sub Section |
HTML Url or PDF Page |
Reviewer |
Comment |
Resolution |
Derby properties :
Sub Section |
HTML Url or PDF Page |
Reviewer |
Comment |
Resolution |
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. |
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..." |
Fixed (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)" |
Fixed (Laura) |