Index only operations
---------------------
Key: CORE-5909
URL: http://tracker.firebirdsql.org/browse/CORE-5909
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Karol Bieniaszewski
Will be good to see index only operations in situation like this:
table with index on SOURCE_ID and the query
SELECT
GS.SOURCE_ID, COUNT(*)
FROM
GAIA_SOURCE GS
GROUP BY GS.SOURCE_ID
HAVING COUNT(*)>1
should go throught index only without visiting table data pages
it is important when working with big databases
e.g. index size can be relatively small compared to table itself.
In my real database index have only 18GB but table have 720GB.
As you can see accessing only 18GB is not the problem - but accessing 720GB is.
same in other places join between tables (using indexed fields) without
returning any other field values from some joined tables.
I suppose this is big change and require REAL TRANSACTIONAL INDEXES.
Current indexes benefit only for intensive updating application.
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
