Re: indexing

"If there are no suitable indexes, then it will use information like B-tree depth, number of rows in each table, distribution of column values to decide which column (s) to do a sequential search on." No indexes means there is no B-tree so there is no B-tree depth to worry about. In this case if there are no appropriate indexes then it will have to look at all of the records so the number of records can't really affect its decision. In some cases informix will build an index but that usually involves a badly formed correlated subquery.