by Denha.. » Sun, 31 Dec 1899 09:00:00
All
Does anybody know if it is possible to construct a report similar to
that produced by set explain using the sysmaster tables in V7?
I know that some of the information is available there, but not sure
about the info on what indexes and filters etc have been chosen.
I am trying to automate the process of detecting sequential scans
and determining the processing path. The purpose of this is to avoid
rerunning the query on a production machine.
Mark
by David William » Sun, 31 Dec 1899 09:00:00
writes
Check out the syssqexplain table...Quote:>All
>Does anybody know if it is possible to construct a report similar to
>that produced by set explain using the sysmaster tables in V7?
Schema will be in $INFORMIXDIR/etc/sysmaster.sql...
>I am trying to automate the process of detecting sequential scans
>and determining the processing path. The purpose of this is to avoid
>rerunning the query on a production machine.
>Mark
Hi All,
I'm trying to gather statistics on queries performed against a none
relational database and one of a relational model. When I execute a query
it seem the non-relational model performs faster, and I cannot decipher the
set explain output. What is meant by Estimated cost? And why does the
faster query (non-relational) have a higher cost? What is estimated # of
rows? The number of rows that are returned by both queries is 9062. But
the relation model estimates 87 and the non-relational estimates 1. I would
appreciate any clarification on this to help me optimize the query path
better.
Thanks
Jay
3. SET EXPLAIN output file for OWS 7.22 on NT?
7. Set Explain -- Please explain
8. database versioning problem
10. Explain Output made Colourful
11. Explain Output made Colorful
12. Sending Explain output to a perl client
13. Help interpreting the output of EXPLAIN