The mi_tstats_setnpages() accessor function

The mi_tstats_setnpages() function stores the number of table pages in the statistics descriptor.

Syntax

void mi_tstats_setnpages(MI_AM_TSTATS_DESC *tstatsDesc,
   mi_integer npages)

tstatsDesc: Points to the statistics descriptor.
npages: provides the number of pages in the table.

Usage

The am_stats purpose function sets the number of data pages, which the database server stores in the npused column of the systables system catalog table. The optimizer uses the number of pages in a table to choose an optimal query path.

Return values

None