[FB-Tracker] Created: (CORE-5500) Add possibility to honor explicitly stored plan without any try of modification

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[FB-Tracker] Created: (CORE-5500) Add possibility to honor explicitly stored plan without any try of modification

JIRA tracker@firebirdsql.org
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