Re: More stupid database tricks
From: <Rene_de_Visser_at_hotmail.com>
Date: Wed, 3 Aug 2005 16:31:42 +0200
Message-ID: <dcqkg6$283$1_at_news.sap-ag.de>
Date: Wed, 3 Aug 2005 16:31:42 +0200
Message-ID: <dcqkg6$283$1_at_news.sap-ag.de>
"Paul" <paul_at_see.my.sig.com> wrote in message
news:a4j1f1prbrn6maevkbksem1lf85be0held_at_4ax.com...
> I saw a critique of this approach (the one table fits all method)
> somewhere on the internet.
> You wouldn't have a link?
>
Try creating a indexes over different selections of those attributes.
Try putting a constraint on the allowed values of one of those attributes.
Try making a join between one relation and another.
Rene. Received on Wed Aug 03 2005 - 16:31:42 CEST