Re: Help with performance

On Wed, Apr 24, 2002 at 10:49:12PM +0200, Uros Gruber wrote:

First you have:
>  id_entry       | integer

Then you have:
>  id_entry    | character varying(64)

> Not i have  query like this
>
> select d.title from table1 d, table2 c where c.id_category='09' and d.id_entry=c.id_entry;

With those types so different, it makes it difficult to use indexes in
certain ways. Perhaps an explicit cast?

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America