Anoop Sharma created TRAFODION-2137:
---------------------------------------
Summary: Improve metadata access time during query compilation
Key: TRAFODION-2137
URL: https://issues.apache.org/jira/browse/TRAFODION-2137
Project: Apache Trafodion
Issue Type: Improvement
Reporter: Anoop Sharma
Assignee: Anoop Sharma
When a trafodion object is accessed for the first time in a session,
information about it is read from metadata.
Multiple metadata tables are read to retrieve information about the
objects being used in the query.
Once metadata info is read about a table, it is cached in compiler memory.
Another query accessing the same object gets it from compiler metadata
cache.
This results in the first query compile performance to be slower than the
subsequent queries accessing the same objects.
This JIRA is to improve performance of first access of an object in
a query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
