Differences between revisions 11 and 12
Revision 11 as of 2006-10-09 22:14:05
Size: 3836
Editor: LauraStewart
Comment:
Revision 12 as of 2009-09-20 22:12:04
Size: 3856
Editor: localhost
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

Working with Derby properties

Performance tips and tricks

Tuning databases and applications

DML statements and performance

Selectivity and cardinality statistics

Rajesh

Complete

Derby properties

Rajesh

Complete

Internal language transformations

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)

TuningTenTwo (last edited 2009-09-20 22:12:04 by localhost)