Le Samedi 23 Avril 2005 14:50, Tobias Rundström a écrit :
> [EMAIL PROTECTED] wrote:
> > Le Samedi 23 Avril 2005 14:34, Tobias Rundström a écrit :
> >>select p.name from packages p join files f on f.pkgid = p.pkgid where
> >>f.filename="/usr/bin/gcc";
> >
> > It is as slow as the previous query :(
>
> Poor indexes? make sure that you have a index on pkgid in both tables
> and one filename.
After the creation of an index on the pkgid column of the table files, it
works far faster : less than one second too :)
Thanks...
