Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Informix > Re: Regarding I...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 21 of 23 Topic 14242 of 15119
Post > Topic >>

Re: Regarding INFORMIX Basic Details

by "Obnoxio The Clown" <obnoxio@[EMAIL PROTECTED] > Jul 2, 2008 at 06:25 PM

Sunil Raja said:
> Hi,
>
>
> 1. why this command is taking more time ( its more than 30 minutes,
> the process is not over ), for just a database with 3 tables and no
> indexes
> ?
> How many rows in the tables? Bigger tables take more time.
>
> *just 1 or 2 rows in each of 3 tables, with no indexes. why is it taking
> so
> long to complete the update statistics.*

Are those the only three tables in the database?

> 2. If this command takes this much time, how can i check whether
> the statistics is working and how can i check whether the statistics of
> the table or index or database have been updated ?

onstat -g sql should show one or more sessions running UPDATE STATS.

> Well, I really, REALLY think you need to read the manual. You've been
sent
> the links.
>
> *Could you please tel me the link again ?*

http://www-306.ibm.com/software/data/informix/pubs/library/ids_94.html

This one probably first:
http://publib.boulder.ibm.com/epubs/pdf/ct1t9na.pdf

-- 
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."
 




 23 Posts in Topic:
Regarding INFORMIX Basic Details
raja <tssr2001@[EMAIL   2008-06-27 05:50:49 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-06-27 13:59:38 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-06-27 14:21:24 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-06-27 14:59:22 
Re: Regarding INFORMIX Basic Details
"Art Kagel" <  2008-06-27 10:49:09 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-06-27 16:03:59 
Re: Regarding INFORMIX Basic Details
"Kevin Cherkauer&quo  2008-06-27 11:12:05 
RE: Regarding INFORMIX Basic Details
"Campbell, John (GE   2008-06-27 14:58:34 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-06-30 22:26:30 
Re: Regarding INFORMIX Basic Details
Fernando Nunes <domuso  2008-06-30 22:53:14 
Re: Regarding INFORMIX Basic Details
DA Morgan <damorgan@[E  2008-06-30 16:54:27 
Re: Regarding INFORMIX Basic Details
Fernando Nunes <domuso  2008-07-01 01:16:45 
Re: Regarding INFORMIX Basic Details
DA Morgan <damorgan@[E  2008-07-01 13:02:16 
Re: Regarding INFORMIX Basic Details
Fernando Nunes <domuso  2008-07-01 22:02:19 
Re: Regarding INFORMIX Basic Details
DA Morgan <damorgan@[E  2008-06-30 16:51:01 
Re: Regarding INFORMIX Basic Details
Fernando Nunes <domuso  2008-07-01 01:31:38 
Re: Regarding INFORMIX Basic Details
DA Morgan <damorgan@[E  2008-07-01 13:04:26 
Re: Regarding INFORMIX Basic Details
Fernando Nunes <domuso  2008-07-01 22:20:35 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-07-01 21:48:43 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-07-02 08:24:29 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-07-02 18:25:01 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-07-03 08:01:50 
Re: Regarding INFORMIX Basic Details
"Obnoxio The Clown&q  2008-07-03 11:07:47 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:43:29 CST 2008.