Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: hiten1972
- Order by date
-
performance degradation after upgrade to 9.4
Hi have you done Update Statistics regards hiten- hiten1972
- Post #2
- Forum: Informix solutions
-
stored procedure to execute OS command?
Hi noobor create table customer ( customer_num serial(101), fname char(15), lname char(15), company char(20), address1 char(20), address2 char(20), city char(15), state...- hiten1972
- Post #2
- Forum: Informix solutions
-
Hi Guys, We have a 40GB Database (
Hi sojan this will help you !! Update statistics has three major functions: a) Compile Stored Procedures b) Dropping / Creating Data distributions c) Collecting Statistics for the Optimizer The improvements in the new release concentrate on b) and c). There are no significant changes to the...- hiten1972
- Post #2
- Forum: Informix solutions
-
Update Stats tips
Hi Kalpana/lloyd Update statistics (Low|Medium|High) Update low mode , no data distribution is created low mode updates only the statistics in the systables,syscolumns and sysindexes system catalog tables. if a mode is not specified then default low mode is used. Best I feel used Update...- hiten1972
- Post #3
- Forum: Informix solutions
-
How to know how long does a query takes
Hi please try this in your query for example set explain on ; select * from a; set explain off it's create sqexplain.out file please check that file Regards Hiten- hiten1972
- Post #2
- Forum: Informix solutions
