page134
117
All is not lost; there are other methods by which you can derive table micro-
partition count:
•
Using a query profile
•
Using
GET_QUERY_OPERATOR_STATS
•
Using
system$clustering_depth
and
system$clustering_
information
You will now examine each in turn.
Query Profile
By issuing a simple query and accessing the query profile, you can readily identify the
number of micro-partitions belonging to a table.
Let’s first set the warehouse to X-Large and then create the example query.
USE WAREHOUSE IDENTIFIER ( $tpc_warehouse_xl );
SELECT *
FROM lineitem_baseline;
Then click the
query_id
, which opens a new tab displaying the Statistics with a
partition count of 9400 and, as an aside, spills to disk as indicated by both Local Disk I/O
and Remote Disk I/O. Both metrics are shown in Figure 4-4.
Figure 4-4.
Query profile micro-partition count
ChaPTer 4
MiCro-ParTiTionS