Re: primary keys and dictionary overhead
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Sun, 23 Oct 2011 12:19:48 +0800
Message-ID: <CAM_ddu-do6zLKW17N+vZJ9-X8yM8hnSnL=stJTXyAst4V3VeZA_at_mail.gmail.com>
two question:
1. what's your motivation to add unique constraints into primary keys? it's from business request, or it's because you believe it the constraint will benifit the performance?
2. There must be a reason why previous guy decide to pull out the constraints, I think there should be a benchmark report to address this decision, see if you can get the document. James Mole did not mention constraint related design in his exceptional book "Scaling Oracle 8i", but he did emphasize the importance of the benchmark in a whole chapter.
Date: Sun, 23 Oct 2011 12:19:48 +0800
Message-ID: <CAM_ddu-do6zLKW17N+vZJ9-X8yM8hnSnL=stJTXyAst4V3VeZA_at_mail.gmail.com>
two question:
1. what's your motivation to add unique constraints into primary keys? it's from business request, or it's because you believe it the constraint will benifit the performance?
2. There must be a reason why previous guy decide to pull out the constraints, I think there should be a benchmark report to address this decision, see if you can get the document. James Mole did not mention constraint related design in his exceptional book "Scaling Oracle 8i", but he did emphasize the importance of the benchmark in a whole chapter.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Regards Sidney Chen -- http://www.freelists.org/webpage/oracle-lReceived on Sat Oct 22 2011 - 23:19:48 CDT