> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# clear_statistics

### clear\_statistics

<ul>
  <li>
    clear\_statistics(\
    &#x20;table\_name?: string,\
    &#x20;column\_name?: string,\
    &#x20;options?: Record\<string, string>,\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/typescript/types/GPUdbCallback.md),\
    ): Promise\<[ClearStatisticsResponse](https://docs.kinetica.com/content/api/typescript/interfaces/ClearStatisticsResponse.md)>

    Clears statistics (cardinality, mean value, etc.) for a column in a specified table.

    #### Parameters

    <ul>
      <li>
        `Optional`table\_name: string

        Name of a table, in \[schema\_name.]table\_name format, using standard name resolution rules. Must be an existing table. A value of '\*' clears statistics on every user table the caller may read (excluding system schemas, views, and temporary tables); when used, `column_name` must be empty.
      </li>

      <li>
        `Optional`column\_name: string

        Name of the column in `table_name` for which to clear statistics. The column must be from an existing table. An empty string clears statistics for all columns in the table. Must be empty when `table_name` is '\*'.
      </li>

      <li>
        `Optional`options: Record\<string, string>

        Optional parameters.
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/typescript/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[ClearStatisticsResponse](https://docs.kinetica.com/content/api/typescript/interfaces/ClearStatisticsResponse.md)>

    Promise\<Types.ClearStatisticsResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:5349](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L5349)</li>
    </ul>
  </li>
</ul>

### clear\_statistics\_request

<ul>
  <li>
    clear\_statistics\_request(\
    &#x20;request: [ClearStatisticsRequest](https://docs.kinetica.com/content/api/typescript/interfaces/ClearStatisticsRequest.md),\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/typescript/types/GPUdbCallback.md),\
    ): Promise\<[ClearStatisticsResponse](https://docs.kinetica.com/content/api/typescript/interfaces/ClearStatisticsResponse.md)>

    Clears statistics (cardinality, mean value, etc.) for a column in a specified table.

    #### Parameters

    <ul>
      <li>
        request: [ClearStatisticsRequest](https://docs.kinetica.com/content/api/typescript/interfaces/ClearStatisticsRequest.md)

        Request object containing the parameters for the operation
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/typescript/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[ClearStatisticsResponse](https://docs.kinetica.com/content/api/typescript/interfaces/ClearStatisticsResponse.md)>

    Promise\<Types.ClearStatisticsResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:5316](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L5316)</li>
    </ul>
  </li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.