View Statistical Details about the Table you Load after you Create a Recipe

After you have created a recipe using the Table AI Assist tool, you can view additional information such as statistics about the table you create. You can generate statistics that measure the data distribution and storage characteristics of the table.

  1. Select the table whose details you want to view.
    1. On the Table AI Assist page, you can either search for the existing table from the search field at the top of the page or view it on the list of tables.
    2. Click Edit Recipe on any of the recipes that were generated from the table.
  2. View information about the tabular data
    1. You can preview the tabular data.
    2. Click Columns tab to view the following information about the table:
      • Table Size (Bytes): Specifies the size of the table in bytes.
      • Number of Rows: Displays the number of rows in the table.
      • Number of Columns: Displays the number of columns in the table.
      • Compressed Size: Displays the size of compressed table in bytes.
      • Statistics Gathered on: Displays date and time of last statistics gathered.
    3. Click Gather Statistics to collect statistics periodically for tables where the statistics become stale over time because of changing data volumes or changes in column values.
  3. Column Statistics:
    • Number of distinct values (NDV) in column

    • Number of nulls in column

    • Data distribution (histogram)

    The above information is displayed in the statistics details of the table.

Was this article helpful?