Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Performance GuideThe Informix® Performance Guide describes how to configure and operate your HCL Informix® database server to improve overall system throughput and to improve the performance of SQL queries.
Indexes and index performance considerationsInformix® provides several types of indexes. Some performance issues are associated with indexes.
Indexes on user-defined data typesYou can define your own data types and the functions that operate on these data types. You can define indexes on some kinds of user-defined data types.
Defining indexes for user-defined data typesAs with built-in data types, you might improve the response time for a query when you define indexes for new data types.
User-defined secondary-access methodsIf the concepts of less than, greater than, and equal do not apply to the data to be indexed, you might consider using a user-defined secondary-access method instead of the built-in secondary-access method, which is a B-tree index. You can use a user-defined secondary-access method to access other indexing structures, such as an R-tree index.
R-tree indexesInformix® supports the R-tree index for columns that contain spatial data such as maps and diagrams. An R-tree index uses a tree structure whose nodes store pointers to lower-level nodes.

R-tree indexes

Informix® supports the R-tree index for columns that contain spatial data such as maps and diagrams. An R-tree index uses a tree structure whose nodes store pointers to lower-level nodes.

At the leaves of the R-tree are a collection of data pages that store n-dimensional shapes. For more information about the structure of an R-tree index and how to estimate the size of an R-tree index, see the Informix R-Tree Index User's Guide.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.