[GitHub] incubator-trafodion pull request: [TRAFODION-1779] Non-optimal pla...

[selvaganesang <gi...@git.apache.org>]

GitHub user selvaganesang opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/287

    [TRAFODION-1779] Non-optimal plan chosen for a query against the crea…

    …ted table
    
    in the same session
    
    The CQD TRAF_RELOAD_NATABLE_CACHE can be turned on to invalidate the cache entry.
    
    The usage will be as follows:
    create table t1 ..
    load into table t1 .. -->This adds the table t1 to NATable cache with estimated row count as 100
    cqd traf_reload_natable_cache 'on' ;
    select * from t1 -->The non-metadata table accessed by this query will be invalidated from
    the NATable cache and reloaded
    cqd traf_reload_natable_cache 'off'
    
    Also removed the use of this CQD in the DDL portion of the codes because it was never used.
    This CQD was used prior to introduction of query invalidation feature.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-1779

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/287.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #287
    
----
commit 91031ce94ea16ddb2e64f7c18ae3647f6e958583
Author: selvaganesang <se...@esgyn.com>
Date:   2016-01-27T01:27:01Z

    [TRAFODION-1779] Non-optimal plan chosen for a query against the created table
    in the same session
    
    The CQD TRAF_RELOAD_NATABLE_CACHE can be turned on to invalidate the cache entry.
    
    The usage will be as follows:
    create table t1 ..
    load into table t1 .. -->This adds the table t1 to NATable cache with estimated row count as 100
    cqd traf_reload_natable_cache 'on' ;
    select * from t1 -->The non-metadata table accessed by this query will be invalidated from
    the NATable cache and reloaded
    cqd traf_reload_natable_cache 'off'
    
    Also removed the use of this CQD in the DDL portion of the codes because it was never used.
    This CQD was used prior to introduction of query invalidation feature.

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-trafodion pull request: [TRAFODION-1779] Non-optimal pla...

[asfgit <gi...@git.apache.org>]

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafodion/pull/287


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---