Home | Previous Page | Next Page   Extending Data Types > Extending the Data Type System >

Optimizer Information

The UPDATE STATISTICS statement collects information for built-in data types. The optimizer uses the information to determine the cost associated with a query.

To collect statistics on opaque and distinct UDTs, you must provide the functions that collect the information. For more information on these functions, see Improving UDR Performance.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]