EXPLAIN result diff. in TEST and REALITY

Posted in 1995

programmer — Fri, 21 Jul 1995 07:47:40 +0200 — source: Informix-list mailing list archive (1991-1998)

In our TEST DB the result of a joined query and SET EXPLAIN is INDEX PATH for the two tables. On our REAL enviroment this result is for one table is SEQUENTIAL SCAN, and for the other one is INDEX PATH. Is this normal ?? The query is awful slow, maybe thatsway ?? Thanks Pal Biro