[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12366851 ]
Mamta A. Satoor commented on DERBY-855:
---
Eric, the latest changes look good to me.
Document optimizer overrides which were introduced in 10.2
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12366446 ]
Mamta A. Satoor commented on DERBY-855:
---
I reviewed the html files and found that the eg for joinOrder incorrectly has
the table names on the same line as optimizer
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365964 ]
Mamta A. Satoor commented on DERBY-855:
---
Eric, I noticed 2 places in ctunoptimzoverride.html, where only single - is
shown in front of DERBY-PROPERTIES. There should be
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365764 ]
Eric Radzinski commented on DERBY-855:
--
sorry...I meant only the second-to-last paragraph is new.
Document optimizer overrides which were introduced in 10.2
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365767 ]
Mamta A. Satoor commented on DERBY-855:
---
Eric, how about rather than less-than-optimal results, we say
less-than-optimal performance? The results word many be mistaken
Jira is down, so sending an email. Ignore the ; I put at the end of the example.
On 2/9/06, Mamta A. Satoor (JIRA) derby-dev@db.apache.org wrote:
[ http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365767
]Mamta A. Satoor commented on
Jira is down, so sending an email. Ignore the ; I put at the end of the example.
- Show quoted text -
On 2/9/06, Mamta A. Satoor (JIRA) derby-dev@db.apache.org wrote:
[ http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365767
]Mamta A. Satoor commented on
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365685 ]
Mamta A. Satoor commented on DERBY-855:
---
Eric, I hope this is the last piece of information I will have to request you
to change. After getting input from Jeff Lichtman
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365521 ]
Mamta A. Satoor commented on DERBY-855:
---
2 comments :
1)The joinOrder and joinStrategy examples have ; at the end of the create
table. We should remove those.
2)Also,
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12365522 ]
Mamta A. Satoor commented on DERBY-855:
---
Eric, one other thing. In the Tuning Guide, under Analyzing the information, I
think you have already added Optimizer Overrides
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364849 ]
Eric Radzinski commented on DERBY-855:
--
There's three open issues on derby-855. I've summarized them here:
--- Does this text adequately address your concern about the
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364658 ]
Mamta A. Satoor commented on DERBY-855:
---
Eric, Thanks for taking care of my comments. The changes look good. Dan had
couple comments too, which I don't think are not
Thanks Mamta,You are correct. I'm still waiting to hear from Dan about my proposed resolutions to his questions. Dan, can I proceed with implementing my proposed resolutions to your questions? They're documented as a commented directly within derby-855."Mamta A. Satoor (JIRA)"
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364698 ]
Daniel John Debrunner commented on DERBY-855:
-
The suggestion for constraint was
constraint
Use the constraint property to override the index that the optimizer
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364700 ]
Daniel John Debrunner commented on DERBY-855:
-
More on the constraint, is the override limited to indexes backing unique and
primary key constaints, or can indexes
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364723 ]
Satheesh Bandaram commented on DERBY-855:
-
I think the contraint override can be used for foreign key constraints as
well... I tried this:
create table prim ( i int
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364747 ]
Daniel John Debrunner commented on DERBY-855:
-
Looks like some improvements could be made in the run time statistics output,
Satheesh's query said
constraint=fk
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364436 ]
Mamta A. Satoor commented on DERBY-855:
---
Couple comments
1)ctunoptimzoverride.html does a good job of cautioning the users to be careful
about the correct syntax when
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364262 ]
Daniel John Debrunner commented on DERBY-855:
-
This section is confusing to me:
constraint
The Derby optimizer chooses an index, including the indexes that
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364265 ]
Eric Radzinski commented on DERBY-855:
--
Regarding your first point, do you suggest to remove the description about the
default optimizer behaviour, and just include
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364115 ]
Eric Radzinski commented on DERBY-855:
--
I have a few outstanding questions about documenting this issue:
--I need some help extracting relevant examples from the source
Hi Eric,
I was busy with a metadata bug so couldn't get back to you sooner. I will post something in the JIRA for this soon.
thanks,
Mamta
On 1/26/06, Eric Radzinski (JIRA) derby-dev@db.apache.org wrote:
[ http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364115
]Eric
[
http://issues.apache.org/jira/browse/DERBY-855?page=comments#action_12364181 ]
Mamta A. Satoor commented on DERBY-855:
---
Following are examples of the 4 optimizer overrides
1)constraint
CREATE TABLE t1 (c1 int, c2 int, c3 int, CONSTRAINT cons1
23 matches
Mail list logo