SET EXPLAIN ON

Applications Programming
1

Hi,
I'm working on INFORMIX4GL, i'm just trying to find out the missing indexes in my db.

I think SET EXPLAIN ON would give me some hint on this

Do anyone know how to use this?

Thanks

2

I am not familar with informix but other DBMSs so yes - explain will show you the access paths for the queries. Have you consulted the informix documenation?