Re: a little help with query.

I run update stats regularly, using dostats. Thanks, floyd ----- Original Message ----- From: "Koya" <chavan1@gmail.com> Sent: Tue, July 7, 2009 16:25 Subject:Re: a little help with query. On Jul 7, 5:42 am, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > No it's not, it's in it's own dbspace. > I tried however ( on a test server ), to drop the index and create it > without any "in" clause, so that it would follow the fragmentation of the > table. That didn't buy me any performance gains. > > > > ----- Original Message ----- > From: "da...@smooth1.co.uk" <da...@smooth1.co.uk> > Sent: Mon, July 6, 2009 15:06 > Subject:Re: a little help with query. > > On 6 July, 16:25, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > > So about 84k records in the table match that profile_token. Not very > unique. > > The query didn't run any faster when I removed the not null clause. So I > guess > this is a disk type performance issue. My onstat -g iov has the inverted > pyramid. > Don't know why else it would take so long. > > > ----- Original Message ----- > > From: "Ian Michael Gumby" >;im_gu...@hotmail.com > > Is the index that it is using fragmented ? > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list > > ----- End of original message ------ Hide quoted text - > > - Show quoted text - What about statistics ? How recent you have the stats for this table and how often and percent of rows will get updates and deletes ? -- Chavan _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ----- End of original message -----