Archives of the TeradataForum
Message Posted: Wed, 28 Sep 2005 @ 10:12:20 GMT
| Subj: | | Re: Partitioned Primary Indices - Is there a way to see |
| |
| From: | | Victor Sokovin |
| | How do I know how many rows are in the partitions? | |
The counts might be provided by the explain plan for a query with aggregate functions imitating the definition of PPI:
www.teradataforum.com/teradata/20041020_191338.htm
.
I do realize this is just a totally ad hoc approach and have no idea where exactly such estimates are coming from. Not sure about their
accuracy either but they were spot on in a few tests I've done in the past.
Regards,
Victor
| 
