The Ingres query optimizer has been enhanced to handle queries that reference large numbers of tables and indexes with shorter response time. For more information, see the SQL Reference Guide.