Because information about the nature and use of a user-defined data type (UDT) is not available to the database server, it cannot collect distributions or the colmin and colmax information (found in the syscolumns system catalog table) for a UDT. Instead, you can create a special function that populates these statistics. The database server runs the statistics collection function when you execute UPDATE STATISTICS.
For more information on the importance of updating statistics, see Statistics Held for the Table and Index. For information on improving performance, see Updating Statistics for Columns with User-Defined Data Types.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]