Re: Design conundrum...
| From: | Stephen van Egmond | Date: | Sat, 23 Jun 2001 20:36:40 +0000 |
| Subject: | Re: Design conundrum... | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9777@lists.php.net to get a copy of this message | ||
Antonio M?rmol Albert (toni@infurma.es) 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.