Add possibility to honor explicitly stored plan without any try of modification
-------------------------------------------------------------------------------
Key: CORE-5500
URL: http://tracker.firebirdsql.org/browse/CORE-5500
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 3.0.0
Reporter: Karol Bieniaszewski
Please provide ability to tell Firebird "do not touch" explicitly stored plan
now we can store plan within query itself
SELECT
...
FROM
...
PLAN ...
ORDER BY ...
but this plan is sometimes adapted by engine and sometimes it do this "wrongly".
Will be good to have some way to prevent this action
I do not know if new "keyword" should be provided
Like "STRICT_PLAN" ...
sample when i store plan for query
PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (RL INDEX
(ROZLICZENIE_FK2,ROZLICZENIE_FK2,ROZLICZENIE_FK2,ROZLICZENIE_FK2,ROZLICZENIE_FK2),
WP INDEX (WPLATA_PK)), U INDEX (UMOWA_PK)), RD INDEX (RODZAJ_DZIAL_PK)), DR
INDEX (DOK_ROZLICZENIOWY_PK)), K INDEX (KONTRAHENT_PK)), W INDEX (WARUNKI_PK)))
engine change it to - and i have no way to prevent that change :(
PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (RL NATURAL), WP INDEX
(WPLATA_PK)), U INDEX (UMOWA_PK)), RD INDEX (RODZAJ_DZIAL_PK)), DR INDEX
(DOK_ROZLICZENIOWY_PK)), K INDEX (KONTRAHENT_PK)), W INDEX (WARUNKI_PK)))
--
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
------------------------------------------------------------------------------
Announcing the Oxford Dictionaries API! The API offers world-renowned
dictionary content that is easy and intuitive to access. Sign up for an
account today to start using our lexical data to power your apps and
projects. Get started today and enter our developer competition.
http://sdm.link/oxford
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
