[jira] [Commented] (DERBY-6921) How good is the Derby Query Optimizer, really

[ https://issues.apache.org/jira/browse/DERBY-6921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15888536#comment-15888536 ] Harshvardhan Gupta commented on DERBY-6921: --- Hi Mr Bryan, I am interested in this project and

[jira] [Comment Edited] (DERBY-6921) How good is the Derby Query Optimizer, really

[ https://issues.apache.org/jira/browse/DERBY-6921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15888536#comment-15888536 ] Harshvardhan Gupta edited comment on DERBY-6921 at 2/28/17 5:46 PM: Hi

[jira] [Commented] (DERBY-6921) How good is the Derby Query Optimizer, really

[ https://issues.apache.org/jira/browse/DERBY-6921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15943436#comment-15943436 ] Harshvardhan Gupta commented on DERBY-6921: --- Thanks for reviewing the proposal. I'll make sure

[jira] [Commented] (DERBY-6921) How good is the Derby Query Optimizer, really

[ https://issues.apache.org/jira/browse/DERBY-6921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15942035#comment-15942035 ] Harshvardhan Gupta commented on DERBY-6921: --- Hi Derby community, I have submitted a draft

[jira] [Commented] (DERBY-6921) How good is the Derby Query Optimizer, really

[ https://issues.apache.org/jira/browse/DERBY-6921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15942086#comment-15942086 ] Harshvardhan Gupta commented on DERBY-6921: --- Hi Kathey, please find the draft proposal at

[jira] [Commented] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15895674#comment-15895674 ] Harshvardhan Gupta commented on DERBY-6904: --- Hi Bryan, I am new to Derby development and would

[jira] [Commented] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15902720#comment-15902720 ] Harshvardhan Gupta commented on DERBY-6904: --- Thanks Bryan for the inputs. I will be adding the

[jira] [Updated] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6904: -- Attachment: 6904.diff The attached patch covers the following issues - DERBY-6904

[jira] [Comment Edited] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906294#comment-15906294 ] Harshvardhan Gupta edited comment on DERBY-6904 at 3/11/17 7:21 PM:

[jira] [Comment Edited] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906294#comment-15906294 ] Harshvardhan Gupta edited comment on DERBY-6904 at 3/11/17 7:20 PM:

[jira] [Updated] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6904: -- Attachment: compareDbName columnMismatch Some of the existing tests are

[jira] [Comment Edited] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15907861#comment-15907861 ] Harshvardhan Gupta edited comment on DERBY-6904 at 3/13/17 5:05 PM:

[jira] [Updated] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6904: -- Attachment: 6904_2.diff Thanks Bryan, Soft Upgrade Strategy - In the attached

[jira] [Commented] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906477#comment-15906477 ] Harshvardhan Gupta commented on DERBY-6904: --- Update on previous comment - I tested with

[jira] [Comment Edited] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906477#comment-15906477 ] Harshvardhan Gupta edited comment on DERBY-6904 at 3/12/17 10:14 AM: -

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16110605#comment-16110605 ] Harshvardhan Gupta commented on DERBY-6938: --- Bryan, I agree with your observations. For

[jira] [Assigned] (DERBY-6954) Allow plans to execute where HASH tables are estimated to spill to disk.

[ https://issues.apache.org/jira/browse/DERBY-6954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6954: - Assignee: Harshvardhan Gupta > Allow plans to execute where HASH tables are

[jira] [Created] (DERBY-6954) Allow plans to execute where HASH tables are estimated to spill to disk.

Harshvardhan Gupta created DERBY-6954: - Summary: Allow plans to execute where HASH tables are estimated to spill to disk. Key: DERBY-6954 URL: https://issues.apache.org/jira/browse/DERBY-6954

[jira] [Commented] (DERBY-6949) Analysis of Derby Cost Estimation

[ https://issues.apache.org/jira/browse/DERBY-6949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16113109#comment-16113109 ] Harshvardhan Gupta commented on DERBY-6949: --- The whole lifecycle of Query Optimization in Derby

[jira] [Comment Edited] (DERBY-6949) Analysis of Derby Cost Estimation

[ https://issues.apache.org/jira/browse/DERBY-6949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16113150#comment-16113150 ] Harshvardhan Gupta edited comment on DERBY-6949 at 8/3/17 5:36 PM: --- By

[jira] [Commented] (DERBY-6949) Analysis of Derby Cost Estimation

[ https://issues.apache.org/jira/browse/DERBY-6949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16113150#comment-16113150 ] Harshvardhan Gupta commented on DERBY-6949: --- By Cost we generally refer to any number

[jira] [Commented] (DERBY-6949) Analysis of Derby Cost Estimation

[ https://issues.apache.org/jira/browse/DERBY-6949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16078310#comment-16078310 ] Harshvardhan Gupta commented on DERBY-6949: --- As part of my work on GSoC 2017, this issue will

[jira] [Created] (DERBY-6949) Analysis of Derby Cost Estimation

Harshvardhan Gupta created DERBY-6949: - Summary: Analysis of Derby Cost Estimation Key: DERBY-6949 URL: https://issues.apache.org/jira/browse/DERBY-6949 Project: Derby Issue Type:

[jira] [Updated] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6942: -- Attachment: DERBY-6942_2.diff Hi Bryan, Attaching the new code based on your

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082789#comment-16082789 ] Harshvardhan Gupta commented on DERBY-6942: --- During the local tests I did, I tested the

[jira] [Comment Edited] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082789#comment-16082789 ] Harshvardhan Gupta edited comment on DERBY-6942 at 7/11/17 7:16 PM:

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16079256#comment-16079256 ] Harshvardhan Gupta commented on DERBY-6942: --- I experimented with integrating max and min values

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16097272#comment-16097272 ] Harshvardhan Gupta commented on DERBY-6938: --- Summarizing my analysis of HASH based joins so far

[jira] [Comment Edited] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16097260#comment-16097260 ] Harshvardhan Gupta edited comment on DERBY-6938 at 7/22/17 11:41 AM: -

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16097260#comment-16097260 ] Harshvardhan Gupta commented on DERBY-6938: --- Hi Bryan, The Optimizer produces memory and cost

[jira] [Updated] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6938: -- Attachment: traceout.txt Following my previous comment I am also attaching the sample

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067124#comment-16067124 ] Harshvardhan Gupta commented on DERBY-6942: --- In particular, when estimating cost for a

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067117#comment-16067117 ] Harshvardhan Gupta commented on DERBY-6942: --- The example I discussed above was quite a simple

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16067113#comment-16067113 ] Harshvardhan Gupta commented on DERBY-6942: --- The estimateCost function in FromBaseTable.java is

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071337#comment-16071337 ] Harshvardhan Gupta commented on DERBY-6942: --- In code, I am trying to query the statistics of

[jira] [Updated] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6942: -- Attachment: z12.txt Please find attached the optimizer trace of a specimen query.

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071405#comment-16071405 ] Harshvardhan Gupta commented on DERBY-6942: --- Let me emphasize on this improvement in case of

[jira] [Updated] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6942: -- Attachment: DERBY-6942.diff z13.txt I was able to solve my problem

[jira] [Comment Edited] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071383#comment-16071383 ] Harshvardhan Gupta edited comment on DERBY-6942 at 7/1/17 8:02 PM: --- I

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071404#comment-16071404 ] Harshvardhan Gupta commented on DERBY-6942: --- Bryan, You are on point! > Utilise additional

[jira] [Commented] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16071413#comment-16071413 ] Harshvardhan Gupta commented on DERBY-6942: --- Yes, the cardinality and cost estimates are both

[jira] [Commented] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16054256#comment-16054256 ] Harshvardhan Gupta commented on DERBY-6905: --- Sorry I meant the junit-all target. > Enhance

[jira] [Commented] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16054252#comment-16054252 ] Harshvardhan Gupta commented on DERBY-6905: --- Hi Bryan, The patch looks good to me but I am

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Attachment: DERBY-6940_3.diff Bryan, Thanks for the help. I was able to solve my

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Description: Derby should collect extra statistics during index build time, statistics

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16058041#comment-16058041 ] Harshvardhan Gupta commented on DERBY-6940: --- Another related link I missed earlier -

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16060091#comment-16060091 ] Harshvardhan Gupta commented on DERBY-6940: --- While debugging the failed test cases I seem to

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16061206#comment-16061206 ] Harshvardhan Gupta commented on DERBY-6940: --- Hi Bryan, I thought of a workaround and was

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16061215#comment-16061215 ] Harshvardhan Gupta commented on DERBY-6940: --- Also, I am creating another issue which will track

[jira] [Commented] (DERBY-3219) Group by query with many aggregate columns and case statements fails with: ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more da

[ https://issues.apache.org/jira/browse/DERBY-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16060086#comment-16060086 ] Harshvardhan Gupta commented on DERBY-3219: --- While examining the failed test cases as part of

[jira] [Created] (DERBY-6942) Utilise additional statistics for selectivity estimates.

Harshvardhan Gupta created DERBY-6942: - Summary: Utilise additional statistics for selectivity estimates. Key: DERBY-6942 URL: https://issues.apache.org/jira/browse/DERBY-6942 Project: Derby

[jira] [Assigned] (DERBY-6942) Utilise additional statistics for selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6942: - Assignee: Harshvardhan Gupta > Utilise additional statistics for selectivity

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16063622#comment-16063622 ] Harshvardhan Gupta commented on DERBY-6940: --- Since I am performing deep copy of the objects, I

[jira] [Commented] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16054502#comment-16054502 ] Harshvardhan Gupta commented on DERBY-6905: --- I can see that dblook_test and others have not been

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Attachment: DERBY-6940_2.diff I am attaching an updated diff which now collects extra

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16056086#comment-16056086 ] Harshvardhan Gupta commented on DERBY-6940: --- I am looking at object serialization as a possible

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16056079#comment-16056079 ] Harshvardhan Gupta commented on DERBY-6940: --- Another thing, I am able to write and read the

[jira] [Updated] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6904: -- Attachment: 6904_3.diff I have completed work on the hard upgrade strategy with the

[jira] [Assigned] (DERBY-6903) ALTER TABLE ALTER COLUMN resets CYCLE option of IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6903: - Assignee: Harshvardhan Gupta > ALTER TABLE ALTER COLUMN resets CYCLE option of

[jira] [Assigned] (DERBY-6906) Allow a GENERATED column to explicitly specify NO CYCLE

[ https://issues.apache.org/jira/browse/DERBY-6906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6906: - Assignee: Harshvardhan Gupta > Allow a GENERATED column to explicitly specify NO

[jira] [Assigned] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6905: - Assignee: Harshvardhan Gupta > Enhance SYS.SYSCOLUMNS to report the CYCLE value

[jira] [Updated] (DERBY-6906) Allow a GENERATED column to explicitly specify NO CYCLE

[ https://issues.apache.org/jira/browse/DERBY-6906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6906: -- Issue Type: Sub-task (was: Improvement) Parent: DERBY-6904 > Allow a GENERATED

[jira] [Updated] (DERBY-6905) Enhance SYS.SYSCOLUMNS to report the CYCLE value for an IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6905: -- Issue Type: Sub-task (was: Improvement) Parent: DERBY-6904 > Enhance

[jira] [Updated] (DERBY-6903) ALTER TABLE ALTER COLUMN resets CYCLE option of IDENTITY column

[ https://issues.apache.org/jira/browse/DERBY-6903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6903: -- Issue Type: Sub-task (was: Bug) Parent: DERBY-6904 > ALTER TABLE ALTER COLUMN

[jira] [Assigned] (DERBY-6921) How good is the Derby Query Optimizer, really

[ https://issues.apache.org/jira/browse/DERBY-6921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6921: - Assignee: Harshvardhan Gupta > How good is the Derby Query Optimizer, really >

[jira] [Updated] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6904: -- Attachment: 6904_4.diff Thanks for reviewing the patch. Your comments are much

[jira] [Comment Edited] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16028473#comment-16028473 ] Harshvardhan Gupta edited comment on DERBY-6904 at 5/29/17 3:55 PM:

[jira] [Assigned] (DERBY-6936) Documentation for changes made as part of DERBY-6904

[ https://issues.apache.org/jira/browse/DERBY-6936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6936: - Assignee: Harshvardhan Gupta > Documentation for changes made as part of

[jira] [Created] (DERBY-6936) Documentation for changes made as part of DERBY-6904

Harshvardhan Gupta created DERBY-6936: - Summary: Documentation for changes made as part of DERBY-6904 Key: DERBY-6936 URL: https://issues.apache.org/jira/browse/DERBY-6936 Project: Derby

[jira] [Created] (DERBY-6935) Test Coverage for added features.

Harshvardhan Gupta created DERBY-6935: - Summary: Test Coverage for added features. Key: DERBY-6935 URL: https://issues.apache.org/jira/browse/DERBY-6935 Project: Derby Issue Type:

[jira] [Comment Edited] (DERBY-6904) Enhance ALTER TABLE to allow CYCLE option to be changed.

[ https://issues.apache.org/jira/browse/DERBY-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16028473#comment-16028473 ] Harshvardhan Gupta edited comment on DERBY-6904 at 5/29/17 3:40 PM:

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16028480#comment-16028480 ] Harshvardhan Gupta commented on DERBY-6935: --- The following functionality should be covered as

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16028482#comment-16028482 ] Harshvardhan Gupta commented on DERBY-6935: --- Hey Bryan, Since most of the functionality we are

[jira] [Updated] (DERBY-6937) Load the IMDB data set in Derby, obtain and adapt Join order Benchmark queries for use in derby

[ https://issues.apache.org/jira/browse/DERBY-6937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6937: -- Attachment: schema_derby.sql I have completed work on this by ingesting the same data

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16036035#comment-16036035 ] Harshvardhan Gupta commented on DERBY-6935: --- Hey Bryan, Yes the tests look good to me and

[jira] [Commented] (DERBY-6937) Load the IMDB data set in Derby, obtain and adapt Join order Benchmark queries for use in derby

[ https://issues.apache.org/jira/browse/DERBY-6937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16036043#comment-16036043 ] Harshvardhan Gupta commented on DERBY-6937: --- Hi Bryan, I modified the derby code to check for

[jira] [Updated] (DERBY-6937) Load the IMDB data set in Derby, obtain and adapt Join order Benchmark queries for use in derby

[ https://issues.apache.org/jira/browse/DERBY-6937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6937: -- Attachment: derby_script.sql imdb.diff Please find the attached files.

[jira] [Created] (DERBY-6937) Load the IMDB data set in Derby, obtain and adapt Join order Benchmark queries for use in derby

Harshvardhan Gupta created DERBY-6937: - Summary: Load the IMDB data set in Derby, obtain and adapt Join order Benchmark queries for use in derby Key: DERBY-6937 URL:

[jira] [Created] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

Harshvardhan Gupta created DERBY-6938: - Summary: Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins. Key: DERBY-6938

[jira] [Updated] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6935: -- Attachment: simpleTests_2.diff Please find attached patch containing updated catalog

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16045556#comment-16045556 ] Harshvardhan Gupta commented on DERBY-6935: --- No, the recent changes to

[jira] [Commented] (DERBY-6936) Documentation for changes made as part of DERBY-6904

[ https://issues.apache.org/jira/browse/DERBY-6936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16045554#comment-16045554 ] Harshvardhan Gupta commented on DERBY-6936: --- Sure Bryan, please go ahead with the changes. >

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16045551#comment-16045551 ] Harshvardhan Gupta commented on DERBY-6935: --- Hi Bryan, I added some catalog tests too in

[jira] [Resolved] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta resolved DERBY-6935. --- Resolution: Fixed > Test Coverage for added features. >

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16046056#comment-16046056 ] Harshvardhan Gupta commented on DERBY-6935: --- Yes, the latest commit looks good. I am resolving

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16046055#comment-16046055 ] Harshvardhan Gupta commented on DERBY-6938: --- Hi Bryan, I am trying to understand the

[jira] [Commented] (DERBY-6936) Documentation for changes made as part of DERBY-6904

[ https://issues.apache.org/jira/browse/DERBY-6936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16046060#comment-16046060 ] Harshvardhan Gupta commented on DERBY-6936: --- The documentation changes seems to cover all the

[jira] [Updated] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6938: -- Attachment: explain.txt Hi Bryan, I am attaching the explain plan of one of the

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16045702#comment-16045702 ] Harshvardhan Gupta commented on DERBY-6935: --- Bryan, Yes the 'moreCycleTests.diff' contains the

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16048793#comment-16048793 ] Harshvardhan Gupta commented on DERBY-6938: --- Bryan, Regarding my doubt earlier, one thing that

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16048780#comment-16048780 ] Harshvardhan Gupta commented on DERBY-6938: --- To view and compare the estimates row counts and

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16048798#comment-16048798 ] Harshvardhan Gupta commented on DERBY-6938: --- The specific approach I am thinking is to keep the

[jira] [Commented] (DERBY-6935) Test Coverage for added features.

[ https://issues.apache.org/jira/browse/DERBY-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16044865#comment-16044865 ] Harshvardhan Gupta commented on DERBY-6935: --- Bryan, I do think that we should go ahead and

[jira] [Comment Edited] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053198#comment-16053198 ] Harshvardhan Gupta edited comment on DERBY-6940 at 6/18/17 1:56 PM:

[jira] [Commented] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053201#comment-16053201 ] Harshvardhan Gupta commented on DERBY-6940: --- Additionally we need to work on upgrade procedures,

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Description: Derby should collect extra statistics during index build time, statistics

[jira] [Updated] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta updated DERBY-6940: -- Attachment: derby-6940.diff Attaching an initial patch which add the following

[jira] [Assigned] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

[ https://issues.apache.org/jira/browse/DERBY-6940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harshvardhan Gupta reassigned DERBY-6940: - Assignee: Harshvardhan Gupta > Enhance derby statistics for more accurate

[jira] [Created] (DERBY-6940) Enhance derby statistics for more accurate selectivity estimates.

Harshvardhan Gupta created DERBY-6940: - Summary: Enhance derby statistics for more accurate selectivity estimates. Key: DERBY-6940 URL: https://issues.apache.org/jira/browse/DERBY-6940 Project:

[jira] [Commented] (DERBY-6938) Obtain cardinality estimates and true estimates for base tables as well as for intermediate results for queries involving multiple joins.

[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16053197#comment-16053197 ] Harshvardhan Gupta commented on DERBY-6938: --- Tracking work on statistics enhancement at

  1   2   >