Sunil Raja said:
> Hi,
>
> Please check the attached jpeg file, i have sent you the output of the
> command that you have asked.
Not quite. Cut and paste this (all three lines) :
time dbaccess test_gema_informix <<!
update statistics;
!
> Please reply to another mail, that i have sent you regarding the version
> difference and autoindex.
1. What are the differences between INFORMIX 9.4 and 10 Versions, ( any
significant features ) ?
Variable page sizes is the main one.
2. What is the difference between autoindex and permanent index ?
Autoindex gets built every time you run the query, it's very slow.
3. How to find all the autoindex in a database ?
You have to run SET EXPLAIN ON for every query.
4. How to eliminate autoindex and create a permanent index ( is it that,
we should always avoid autoindex ? ) ?
Yes, you should always avoid them and you avoid them by building indexes
with the CREATE INDEX statement. And I don't know what indexes you should
build, but the ones that autoindex builds are probably a good place to
start. ;o)
> On Thu, Jul 3, 2008 at 12:31 PM, Obnoxio The Clown
> <obnoxio@[EMAIL PROTECTED]
>
> wrote:
>
>>
>> Sunil Raja said:
>> > Are those the only three tables in the database?
>> > Yes. It took more than 30 minutes, still the update statistics
process
>> > didnt
>> > get completed. why is it taking so long time ?
>>
>> So you have only three tables in the database, each with only a handful
>> of
>> rows in and update statistics is taking more than 30 minutes?
>>
>> I'm not going to call you a liar, but I am curious. :o)
>>
>> Run this:
>>
>> time dbaccess yourdatabasename <<!
>> update statistics;
>> !
>>
>> And tell me what it says.
>>
>> --
>> 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."
>>
>>
>>
>
>
>
--
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."
|
