On 5 Feb 2010, at 5:05am, Kelly Jones wrote:
> I have a query that runs very quickly and returns no results:
>
> SELECT * FROM filebackup WHERE sha1='x';
>
> However, the more restrictive query below runs very slowly, although
> it obviously can't have any results either:
>
> SELECT * FROM
I have a query that runs very quickly and returns no results:
SELECT * FROM filebackup WHERE sha1='x';
However, the more restrictive query below runs very slowly, although
it obviously can't have any results either:
SELECT * FROM filebackup WHERE sha1='x' AND refid=0;
I have indexes on both
2 matches
Mail list logo