Re: Regarding INFORMIX Basic Details

Obnoxio The Clown wrote:
> 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?

It's the oracle term for update statistics.
You can check the systables record for the table in new versions.
In old versions you can only check the sysdistrib table, but this will
only 
have records if you run UPDATE STATISTICS medium/high... (with histograms)

> 
>> 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 ?

More or less the same as any other database: Run it, check the query plan,

understand if it is the right one an test others (using hints for example)

> 
> Huh?
> 
>> 5. What are the ways to tune a procedure in INFORMIX ?

Tune the queries it runs...

> 
> Huh?
>