Antonio M?rmol Albert ([EMAIL PROTECTED]) wrote:
> With index in the third table, How would it be ?
It depends on the dynamics of the application.
1) If you have to ask "what cateogories does the editor edit?", you
create an index on editor.
2) If you have toa sk "what editors does this category have?", you
create an index on category.
For correctness (but not efficiency) a unique index on (editor,
category) would be needed.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
