Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Lauri Pietarinen — — source: Informix-list mailing list archive (1991-1998)
Is it possible to get the explanation of an access path without
executing the query?
Now the steps to be taken are...
1. execute "set explain on"
2. execute the query
When operating against a big database, it would be nice to know in
advance
if the access path will be reasonable.
Lauri Pietarinen
AtBusiness Communications
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.