>>9) Check for orphaned Path records
>>SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER JOIN File
>>ON (Path.PathId=File.PathId) WHERE File.PathId IS NULL LIMIT 300000
>
>This one should work if you have created this index:
>
>create index PathId on File (PathId);

Oh, I have just seen that this index is already there.

Please post the result of the explain command.


Cheers, Primus.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users