例: 地理空間列の統計が収集されているテーブルに対するVALUES句を使用したSHOW STATISTICS - Advanced SQL Engine - Teradata Database

次のCOLLECT STATISTICSリクエストを実行したとします。

     COLLECT STATISTICS
       COLUMN o_warehouseloc
     ON orders;

次のSHOW STATISTICSリクエストは、o_warehouseloc列に対するVALUES句を含むCOLLECT STATISTICS SQLテキストを報告します。この列は、注文品が出荷される倉庫の経度と緯度を特定するポイントが含まれる地理空間列です。

     SHOW STATISTICS VALUES COLUMN o_warehouseloc ON orders;
     COLLECT STATISTICS 
                COLUMN "o_warehouseloc" 
     ON "orders"
       VALUES
    (
    'EIXSTATKIND', 'GEOSPATIAL', TIMESTAMP '2013-05-01 20:35:04',
    'Version', 1,
    'NumAMPs', 4,
    'SizeOfLowResGeoGrid', 1024,
    'SizeOfHighResGeoGrid', 16384,
    'NumberHighResCells', 0,
    'MBRxLow', 2.00000000000000E 000,
    'MBRyLow', 2.00000000000000E 000,
    'MBRxHigh', 2.70000000000000E 001,
    'MBRyHigh', 2.70000000000000E 001,
    'SkewMBRxLow', 2.00000000000000E 000,
    'SkewMBRyLow', 2.00000000000000E 000,
    'SkewMBRxHigh', 1.68437500000000E 001,
    'SkewMBRyHigh', 1.60625000000000E 001,
    'NumberNulls', 0,
    'NumberRows', 174,
    'NumberOutliers', 7,
    'AvgMBRWidth', 7.00000000000000E 000,
    'AvgMBRHeight', 7.00000000000000E 000,
    'TotalIC', 42522,
    'TotalDC', 0,
    'MudCount', 1.80000000000000E 001,
    'NumberLevels', 2,
    'NumberLeafBlks', 1,
    'NumberLeafRows', 3,
    'NumberLeafEntries', 44,
    'LeafRowSpaceUtilization', 568,
    'NumberDirBlks', 1,
    'NumberDirRows', 1,
    'NumberPoints', 0.00000000000000E 000,
    'NumberLineString', 0.00000000000000E 000,
    'AvgSizeLineString', 0,
    'NumberPolygon', 1.74000000000000E 002,
    'AvgSizePolygon', 125,
    'NumberGeomColl', 0.00000000000000E 000,
    'AvgSizeGeomColl', 0,
    'NumberMultiPoint', 0.00000000000000E 000,
    'AvgSizeMultiPoint', 0,
    'NumberMultiLineString', 0.00000000000000E 000,
    'AvgSizeMultiLineString', 0,
    'NumberMultiPolygon', 0.00000000000000E 000,
    'AvgSizeMultiPolygon', 0,
    'LowResCells', 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
    1.62000000000000E 002, 0.00000000000000E 000,
            o                        o
            o                        o
            o                        o
     );