=20
-----Original Message-----
From: informix-list-bounces@[EMAIL PROTECTED]
On Behalf Of raja
Sent: Friday, June 27, 2008 8:51 AM
To: informix-list@[EMAIL PROTECTED]
Regarding INFORMIX Basic Details
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,... ) ?
Dbschema ---
2. What is dbaccess in INFORMIX ?
Similar to sqlplus
3. How to execute a sql script file in INFORMIX ?
Dbaccess -e <database> <filename.sql> or run it from the dbaccess menu
4. What are the list of tables, that related to DBA, to tune the
database ?
You might look for the sysmaster tables in the Admin Guide
5. What are the tuning tools in INFORMIX ?
Onstat, oncheck, explain,=20
6. What is in INFORMIX, similar to statspack/AWR Re****t in ORACLE ?
Nothing other than tools mentioned above.
7. What are the ways to tune a sql query in INFORMIX ?
8. What are the ways to tune a procedure in INFORMIX ?
What do you mean tune a query or procedure? You can run explain on a
quey to see its execution plan.=20
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.
I don't have a url but the do***entation is out there.
Thanks in Advance.
With Regards,
Raja.
_______________________________________________
Informix-list mailing list
Informix-list@[EMAIL PROTECTED]
|
