Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Introduction, 6 of 7


SDO_TUNE Package

Table 1-6 SDO_TUNE Package Subprograms  
Subprogram  Description 

ANALYZE_RTREE 

Analyzes an R-tree index; generates statistics about the index use, and recommends a rebuild of the index if a rebuild would improve query performance significantly. 

AVERAGE_MBR 

Calculates the average minimum bounding rectangle for geometries in a layer. 

ESTIMATE_INDEX_PERFORMANCE 

Estimates the spatial index selectivity. 

ESTIMATE_TILING_LEVEL 

Determines an appropriate tiling level for creating fixed-size index tiles. 

ESTIMATE_TILING_TIME 

Estimates the tiling time for a layer, in seconds. 

ESTIMATE_TOTAL_NUMTILES 

Estimates the total number of spatial tiles for a layer. 

EXTENT_OF 

Determines the minimum bounding rectangle of the data in a layer. 

HISTOGRAM_ANALYSIS 

Calculates statistical histograms for a spatial layer. 

MIX_INFO 

Calculates geometry type information for a spatial layer, such as the percentage of each geometry type. 

QUALITY_DEGRADATION 

Returns the quality degradation for an R-tree index or the average quality degradation for all index tables for an R-tree index. 

RTREE_QUALITY 

Returns the quality score for an R-tree index or the average quality score for all index tables for an R-tree index. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback