You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Manjula Kutty (JIRA)" <de...@db.apache.org> on 2006/04/26 21:21:05 UTC
[jira] Created: (DERBY-1257) Enhance Derby optimizer and execution
model to support effective use of multiple indexes on one table. Derby
currently can use one index on a table and there are many situations where
using multiple indexes on a table could improve performance significant
Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significant
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-1257
URL: http://issues.apache.org/jira/browse/DERBY-1257
Project: Derby
Type: Improvement
Components: Performance
Versions: 10.2.0.0
Reporter: Manjula Kutty
Priority: Minor
Fix For: 10.2.0.0
Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significantly. Please see the discussion at http://article.gmane.org/gmane.comp.apache.db.derby.devel/16099
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1257) Enhance Derby optimizer and execution
model to support effective use of multiple indexes on one table. Derby
currently can use one index on a table and there are many situations where
using multiple indexes on a table could improve performance significant
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-1257:
---------------------------------
Component/s: SQL
> Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significant
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1257
> URL: https://issues.apache.org/jira/browse/DERBY-1257
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.2.1.6
> Reporter: Manjula Kutty
> Priority: Minor
>
> Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significantly. Please see the discussion at http://article.gmane.org/gmane.comp.apache.db.derby.devel/16099
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1257) Enhance Derby optimizer and execution
model to support effective use of multiple indexes on one table. Derby
currently can use one index on a table and there are many situations where
using multiple indexes on a table could improve performance significant
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-1257:
---------------------------------
Derby Categories: [Performance]
> Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significant
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1257
> URL: https://issues.apache.org/jira/browse/DERBY-1257
> Project: Derby
> Issue Type: Improvement
> Affects Versions: 10.2.1.6
> Reporter: Manjula Kutty
> Priority: Minor
>
> Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significantly. Please see the discussion at http://article.gmane.org/gmane.comp.apache.db.derby.devel/16099
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1257) Enhance Derby optimizer and execution
model to support effective use of multiple indexes on one table. Derby
currently can use one index on a table and there are many situations where
using multiple indexes on a table could improve performance significant
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1257?page=all ]
Kathey Marsden updated DERBY-1257:
----------------------------------
Fix Version/s: 10.3.0.0
(was: 10.2.0.0)
Since this remains unassigned I don't think it reasonable to think someone will pick it up and fix it for 10.2. Looks like a high value fix for 10.3 though.
Changing to 10.3
> Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significant
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1257
> URL: http://issues.apache.org/jira/browse/DERBY-1257
> Project: Derby
> Issue Type: Improvement
> Components: Performance
> Affects Versions: 10.2.0.0
> Reporter: Manjula Kutty
> Priority: Minor
> Fix For: 10.3.0.0
>
>
> Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significantly. Please see the discussion at http://article.gmane.org/gmane.comp.apache.db.derby.devel/16099
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira