raja said:
> Hi 2 All,
>
> I am new to INFORMIX database.
>
> I am using INFORMIX 9.4 database in HP-UX System.
>
> I have few questions, Please clarify those questions for me :
>
> 1. What is in INFORMIX, similar to sqlplus in ORACLE ( to view the
> schema details - tables, indexes,... ) ?
See question 2.
> 2. What is dbaccess in INFORMIX ?
See question 1.
> 3. How to execute a sql script file in INFORMIX ?
See question 2.
> 4. What are the list of tables, that related to DBA, to tune the
> database ?
$INFORMIXDIR/etc/onconfig
> 5. What are the tuning tools in INFORMIX ?
See question 4.
> 6. What is in INFORMIX, similar to statspack/AWR Re****t in ORACLE ?
Pass. onstat, perhaps?
> 7. What are the ways to tune a sql query in INFORMIX ?
Optimiser directives.
> 8. What are the ways to tune a procedure in INFORMIX ?
Code it better.
> I would be very much thankful, if you Please explain me these
> questions separately with Examples.
> If you have any do***ents or URL, Please send me them.
http://www-306.ibm.com/software/data/informix/pubs/library/
--
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."
|
