Re: How can I tell infomix which is the best index to use

first off thanks for all the replies I tried create index table_1 on table(date_time, acct_number);account_number <= 123 and account_number >= 123 both with no proformace increase update statistics for table table_name did give me a signicant increase I have no idea what this does and the books I have dont seem to mention it could sombody give me a clue