Re: a little help with query.

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: "david@smooth1.co.uk" <david@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-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ----- End of original message -----

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