Improve query plan output by including table alias name along with the table
names.
-----------------------------------------------------------------------------------
Key: DERBY-4123
URL: https://issues.apache.org/jira/browse/DERBY-4123
Project: Derby
Issue Type: Improvement
Components: Miscellaneous
Reporter: Mamta A. Satoor
Priority: Minor
Derby allows user to look at a query plan by
call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)
run the query
VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
If the query involved does a self jon, in the query plan, we do not distinguish
between the tables. For instance, for the query below
SELECT table1.id, m0.value, m1.value FROM table1, table2 m0, table2 m1 WHERE
table1.id=m0.id AND m0.name ='PageSequenceId' AND table1.id=m1.id AND
m1.name='PostComponentId' AND m1.value='21857' ORDER BY m0.value;
when we print the info on the query plan, both instances of table2 which are m0
and m1 are referred in the plan as simply table2. It will be good for us to
include the alias name as well to know exactly which table is involved.
The query above along with the tables and related index creation can be found
in DERBY-3926 (attachment derby-reproduce.zip)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
