Skip to content

Support Products Reference Training

Talk to an expert →

Support Products Reference Training

Talk to an expert →

Home
Training
Quick SQL Tutorial
Database Optimisation

Indexing

Index Theory
Index Structure
Types of Index
The Dos and Don'ts of Indexing
Creating an Index
Clustered Indices

Advanced Select

Advanced Select
Subqueries Returning Multiple Values
Using the EXISTS Condition
Outer Joins
Union
The Intersection and Difference Set Operators
Self Joins
Synonyms

Query Optimisation

Query Optimisation
Optimiser Requirements
The SET OPTIMIZATION Statement
The Informix Query Optimisation Process
The SET EXPLAIN Statement
The Order of SELECT Statement Clause Processing
Database Optimisation
User Optimisation of a Query

Security and Integrity

Security and Integrity
User Access
Database Access
Object Level Privileges
Views
Transaction Work

Database Optimisation

Oninit LLC

The Down System Specialists.
Independent Informix and Unix consultancy serving enterprises worldwide since the 1990s.

About

About Oninit
Partnership
What We Do For You
Services
Glossary

Legal

Legal Center
Terms of Service
Privacy Policy
Acceptable Use
Security
Cookie settings

Contact

+1 913 732 8892
+44 20 8133 7529
Talk to an expert
info@oninit.com