On Fri, 18 Jun 2004, Jeff Rogers wrote:
> create table articles (
> topic varchar(50),
> created date,
> data text
> );
>
> create index articles_topic_idx on articles(topic);
> create index articles_created_idx on articles(created);
>
> If I want to get the 5 most recent articles in a topic
some new choices for plans.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Rogers
> Sent: Friday, June 18, 2004 12:28 PM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] can't win
>
>
>
> I have a query that
I have a query that it seems is destined to be slow one way or another. I
have a table of around 30k articles, categorized by topic and ordered by date:
create table articles (
topic varchar(50),
created date,
data text
);
create index articles_topic_idx on articles(topic);
create index
