Re: [PERFORM] force the use of a particular index

2003-07-11 Thread Scott Cain
of query I perform on the database. Thanks, Scott On Fri, 2003-07-11 at 06:51, Rod Taylor wrote: On Thu, 2003-07-10 at 15:18, Scott Cain wrote: Hello, I am wondering if there is a way to force the use of a particular index when doing a query. I have two tables that are pretty big (each 3

Re: [PERFORM] force the use of a particular index

2003-07-11 Thread Scott Cain
=13825 loops=1) Filter: (type_id = 219) Total runtime: 63632.28 msec (12 rows) Any other ideas? Thanks, Scott On Fri, 2003-07-11 at 09:38, Rod Taylor wrote: On Fri, 2003-07-11 at 13:17, Scott Cain wrote: The problem (at least as it appears to me

Re: [PERFORM] EXTERNAL storage and substring on long strings

2003-08-04 Thread Scott Cain
-- Scott Cain, Ph. D. [EMAIL PROTECTED] GMOD Coordinator (http://www.gmod.org/) 216-392-3087 Cold Spring Harbor Laboratory ---(end of broadcast)--- TIP 3: if posting/reading

Re: [SQL] [PERFORM] EXTERNAL storage and substring on long strings

2003-08-08 Thread Scott Cain
Oh, and I forgot to mention: it's highly compressed (bzip2 -9) and is 109M. Scott On Tue, 2003-08-05 at 11:01, Scott Cain wrote: Joe, Good idea, since I may not get around to profiling it this week. I created a dump of the data set I was working with. It is available at http