Hello,
On Fri, Dec 05, 2003 at 12:02:05PM +0100, Martin Gillstr?m wrote:
>
> The table can look something like this:
> row_id INT PRIMARY KEY
> where_column SET('a','b','c')
> groupby_column VARCHAR(255)
> orderby_column DATE
> .. more rows that I need to fetch with the select.
> This is what I
Hi,
I have a table with about 500 000 rows and need to execute a query with
first a WHERE then a GROUP BY and then ORDER BY all on different columns
is their any way to optimize this?
The table can look something like this:
row_id INT PRIMARY KEY
where_column SET('a','b','c')
groupby_column VAR