Hi, I'm looking at some search engine where we can have up to 14-15 categories and each categories have about 5-10 option (checkbox)
my question is if we have a complex query like this would it be better to split some categories in tables i.e we have 21 different categories should we have 7 tables(indexed) with three columns, then do a big join statment?? or any other better way? awards
