Temporary Indexes to optimize some occasional query
---------------------------------------------------
Key: CORE-3975
URL: http://tracker.firebirdsql.org/browse/CORE-3975
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Will be good to see feature to create temporary indexes for some query
Sometimes permanent index is not good and can slowdown inserts and other
operations
but some query without index can run to long without index
this can be don in two ways
1. explicit creation of temporary index by user request
like CREATE TEMPORARY INDEX TIDX_TEST__XXX ON TEST(XXX) [ON COMMIT {DELETE |
PRESERVE}];
2. automatic by engine look at this in IBM
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzajq%2Frzajqtempindex.htm
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
