Index

• Access methods, general (1), (2)
  • See also R-tree access method.
  • B-tree (1), (2)
  • Informix Dynamic Server provides
  • primary (1), (2)
  • secondary (1), (2)
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader

• B-tree access method (1), (2), (3)
• B-tree index vs R-tree
• bbox_only_distance operation key
• BladeManager (1), (2)
• BladeSmith (1), (2), (3)
• Boldface type
• Bottom-up build (1), (2)
• BOTTOM_UP_BUILD index parameter (1), (2)
• BOUNDING_BOX_INDEX index parameter (1), (2)
• Bounding-box-only indexes (1), (2), (3)
• Bounding boxes
  • checking with the oncheck utility
  • discussion of (1), (2), (3)
  • effectiveness of
  • finding coordinates of root bounding box (1), (2)
  • loose (1), (2), (3)
  • strategy function switching semantics
  • with Contains strategy function
  • with Overlap strategy function
  • with Within strategy function
• Branch page
• Bulk-loading data support functions
• Bulk-loading of data (1), (2)

• Casts, implicit (1), (2)
• Cleaning up an R-tree index
• Clustering spatial data on the disk
• Code, sample, conventions for
• Command-line conventions
  • how to read
  • sample diagram
• COMMITTED READ isolation level
• Commutator functions (1), (2), (3)
• Compliance
  • with industry standards
• Concurrency using R-link trees
• Contact information
• Contains strategy function (1), (2), (3), (4)
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Cost, using R-tree index (1), (2)
• Cost functions
• CREATE OPCLASS statement
• Creating operator classes
• Creating R-tree indexes
• Creating registration scripts for dependent DataBlade modules
• CURSOR STABILITY isolation level

• Data-access cost
• Data objects (1), (2), (3), (4)
• Data type hierarchies
• DataBlade API (1), (2), (3), (4), (5)
• DataBlade Developers Kit (DBDK) (1), (2), (3), (4), (5), (6), (7), (8), (9)
• DataBlade module development (1), (2), (3), (4)
• DataBlade modules
  • that use R-tree (1), (2)
• Default locale
• Default R-tree operator class, rtree_ops (1), (2), (3), (4)
• Dependencies, software
• Designing user-defined data types (1), (2), (3)
• DIRTY READ isolation level
• Disabilities, visual
  • reading syntax diagrams
• Distance-measuring function
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dotted decimal format of syntax diagrams
• Dropping R-tree indexes
• DS_MAX_QUERIES ONCONFIG parameter
• DS_TOTAL_MEMORY ONCONFIG parameter

• en_us.8859-1 locale
• Environment variables
• Equal strategy function (1), (2)
• Error messages
• Error messages of the R-tree secondary access method (1), (2)
• Estimating the size of an R-tree index

• FILLFACTOR index parameter (1), (2)
• Filtering cost
• FIRST n syntax
• Fixed and Known Defects File
• FRAGMENT, option to CREATE INDEX statement
• Fragmented R-tree indexes (1), (2)
• Functional R-tree indexes (1), (2)

• Geodetic DataBlade module (1), (2)
• GeoObject_ops, operator class of Informix Geodetic DataBlade module
• Global Language Support (GLS)

• Help
• Hierarchies, of data types

• ifxrltree interface object
• Implicit casts (1), (2)
• Importing the ifxrltree interface object
• IN, option to CREATE INDEX statement
• Index parameters
  • BOTTOM_UP_BUILD (1), (2)
  • BOUNDING_BOX_INDEX
  • FILLFACTOR (1), (2)
  • NO_SORT
  • SORT_MEMORY (1), (2)
  • specifying (1), (2)
• Industry standards, compliance with
• Informix Dynamic Server (1), (2), (3), (4), (5), (6)
• Informix Dynamic Server documentation set
• Informix Geodetic DataBlade module (1), (2)
• Informix R-Tree Secondary Access Method DataBlade module
  • contents of
  • creating dependencies on
  • registering (1), (2)
• Informix Spatial DataBlade module (1), (2), (3)
• Informix Video Foundation DataBlade module
• Inserting data into an R-tree index
• Installation Guides
• Installing DataBlade modules
• Inter support function (1), (2)
• Interface object ifxrltree
• Internal C structure of user-defined data type
• ISO 8859-1 code set
• Isolation levels and R-tree indexes

• Keywords
  • in syntax diagrams

• Leaf page (1), (2)
  • strategy function switching semantics
• Loading data into an R-tree index
• Locale
• Locking of R-tree index
• Logging and R-tree indexes
• Loose bounding boxes (1), (2), (3)

• Machine notes
• Maximum size of the user-defined data type

• nearest_neighbor_functions operation key
• Nearest-neighbor searches (1), (2), (3)
• Nearest-neighbor strategy function
• NO_SORT index parameter (1), (2)
• Null values in R-tree index

• ObjectLength support function (1), (2), (3), (4)
• oncheck utility (1), (2), (3), (4)
• ONCONFIG parameters
  • DS_MAX_QUERIES
  • DS_TOTAL_MEMORY
• Online help
• Online manuals
• Online notes (1), (2)
• onlog utility
• Operator classes
  • creating (1), (2)
  • discussion of (1), (2), (3)
  • requirements for R-tree access method
  • specifying in CREATE INDEX statement
  • strategy functions (1), (2), (3), (4), (5), (6)
  • support functions (1), (2), (3), (4)
• Overlap strategy function (1), (2), (3), (4), (5)

• Page splitting (1), (2), (3)
• Per-row cost functions
• Performance
  • clustering spatial data on the disk
  • deleting rows from an indexed table
  • effectiveness of bounding box representations
  • updating statistics
• Primary access method
• Printed manuals
• Purpose functions

• Query optimizer

• R-link trees
• R-tree indexes
  • and database isolation levels
  • and logging
  • and null values
  • checking with the oncheck utility
  • contents of leaf page
  • contents of root or branch page
  • creating
  • description of logical log records
  • dropping
  • estimating the size of
  • example of creating
  • example of creating fragmented (1), (2)
  • fragmenting
  • functional
  • improving performance of
  • improving performance of deletions from
  • inserting into
  • loading data into
  • locking of
  • page splitting (figure) (1), (2)
  • page splitting in (1), (2), (3)
  • performing a cleanup of
  • purpose of
  • searching with
  • sequence numbers in
  • steps to perform before creating
  • storing
  • structure of (1), (2)
  • structure of (figure)
  • subtrees of
  • supported CREATE INDEX options
  • updating statistics for (1), (2), (3)
  • viewing logical log records of
  • vs B-tree
  • when used by query optimizer
• R-tree secondary access method
  • creating operator classes for
  • deciding whether to use
  • discussion of
  • error messages
  • example in DBDK (1), (2), (3)
  • functionality Informix provides
  • specifying
  • system catalogs (1), (2), (3)
  • types of data indexed by (1), (2)
• R-Tree Secondary Access Method DataBlade module
  • contents of
  • creating dependencies on
  • registering (1), (2)
• Refinement cost
• Registering DataBlade modules
• Registering selectivity and cost functions
• Release Notes
• REPEATABLE READ isolation level
• Right-pointing link
• Root page (1), (2)
• Rowid
• rtree_ops, default R-tree operator class (1), (2), (3), (4)
• RtreeInfo support function (1), (2), (3), (4)
  • nearest-neighbor searches
• rtreeRootBB() function (1), (2)

• Sample-code conventions
• Screen reader
  • reading syntax diagrams
• SE_Nearest function
• SE_NearestBBox function
• Search object
• Searching with an R-tree index
• Secondary access method, general
• Selectivity functions
• Selectivity of data
• Sequence numbers in R-tree indexes
• SetUnion support function (1), (2), (3), (4)
• SFCbits support function (1), (2), (3), (4)
• SFCvalue support function (1), (2), (3), (4)
• Size support function (1), (2), (3)
• Software dependencies
• SORT_MEMORY index parameter (1), (2)
• Sorted tables
• Spatial DataBlade module (1), (2)
• Spatial key
• Specifying the R-tree secondary access method
• SQL code
• Statistics, updating (1), (2), (3)
• Storage of R-tree indexes
• stores_demo database
• Strategy functions
  • commutators of (1), (2), (3)
  • Contains (1), (2), (3), (4)
  • creating (1), (2)
  • designing
  • discussion of (1), (2), (3), (4)
  • Equal (1), (2)
  • example of creating
  • in a data type hierarchy
  • internal uses of
  • other types of
  • Overlap (1), (2), (3), (4), (5)
  • switching semantics
  • Within (1), (2)
• Structure of an R-tree index
• Subtrees of an R-tree index
• Subtypes, in a data type hierarchy
• superstores_demo database
• Supertypes, in a data type hierarchy
• Support functions
  • designing
  • discussion of (1), (2)
  • example of creating
  • for bulk-loading of data
  • in a data type hierarchy
  • Inter (1), (2)
  • internal uses of
  • ObjectLength (1), (2), (3), (4)
  • required for R-tree secondary access method (1), (2)
  • SetUnion (1), (2), (3), (4)
  • SFCbits (1), (2), (3), (4)
  • SFCvalue (1), (2), (3), (4)
  • Size (1), (2), (3)
  • Union (1), (2)
• Switching semantics, strategy functions
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax segment
• sysams system catalog
• sysindices system catalog
• sysopclasses system catalog
• System catalogs
  • sysams
  • sysindices
  • sysopclasses
• System requirements
  • database
  • software

• TOC Notes
• Types of data indexed by R-tree secondary access method
• Types of data R-tree secondary access method indexes
• Typographical conventions

• Union support function (1), (2)
• UPDATE STATISTICS, cost of using index
• UPDATE STATISTICS command (1), (2)
• Updating statistics (1), (2), (3)
• User-defined data types, designing for R-tree indexes (1), (2), (3)
• Utilities
  • oncheck (1), (2)
  • onlog

• Variables, in syntax diagrams
• Video Foundation DataBlade module
• Virtual-Index Interface (VII)
• Visual disabilities
  • reading syntax diagrams

• Within strategy function (1), (2)