You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/10/07 10:51:33 UTC
[jira] [Commented] (PHOENIX-1328) Update ANALYZE syntax to collect
stats on index tables and all tables
[ https://issues.apache.org/jira/browse/PHOENIX-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14161649#comment-14161649 ]
James Taylor commented on PHOENIX-1328:
---------------------------------------
You can do an UPDATE STATISTICS on a table/index, it's indexes, or both the table and indexes (default). LIke this:
- UPDATE STATISTICS <table> INDEX ------ Updates the statistics of all indexes on the table
- UPDATE STATISTICS <table> ALL ------ Updates both the table and index statistics
- UPDATE STATISTICS <table> ------- Same as ALL
- UPDATE STATISTICS <table> COLUMNS ------- Updates only the table statistics
- UPDATE STATISTICS <index> ------- Updates only the index statistics
> Update ANALYZE syntax to collect stats on index tables and all tables
> ---------------------------------------------------------------------
>
> Key: PHOENIX-1328
> URL: https://issues.apache.org/jira/browse/PHOENIX-1328
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: ramkrishna.s.vasudevan
> Assignee: ramkrishna.s.vasudevan
>
> Based on the discussion in PHOENIX-1309 we will now modify the ANALYZE query to collect the stats for index table and all the tables associated with the main table (includes index).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)