Re: multi-dimensional range lookup

How many datasets are in the database?

Do you have indexes on the columns included in your query?

Comment on Re: multi-dimensional range lookup

Replies are listed 'Best First'.
Re^2: multi-dimensional range lookup by danmcc (Novice) on May 10, 2007 at 17:12 UTC
Hi, There are about three million rows in the table. There is a multi-column index on the r, g, and b columns, as well as individual indexes on each of the r, g, and, b columns. danmcc	[reply]