Sunil Raja said:
> Hi,
>
> Thanks for your suggestions, Had a view at onstat, onconfig file,
> sysmaster
> tables, systables,...
>
> Please clarify me the following questions :
>
> 1. How / Where can i find whether a table/index/... is analyzed or not ?
> and
> when was it analyzed last ( last date analyzed ) ?
What do you mean analysed?
> 2. How to analyze a particular table or index or entire schema ? (
Please
> explain with example, as got confused with high, low and
> medium parameters... )
Download the utils2_ak bundle from iiug.org, and use the dostats utility.
> 3. How to run/execute a sql script and view the output in dbaccess ?
dbaccess databasename scriptname.sql | more
> 4. What are the ways to tune a sql query in INFORMIX ?
Huh?
> 5. What are the ways to tune a procedure in INFORMIX ?
Huh?
--
Bye now,
Obnoxio
"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."


|