Re: Schema Design Question
From: Kumar <kumar_kmk_at_hotmail.com>
Date: 28 Dec 2001 22:43:36 -0800
Message-ID: <bce41b15.0112282243.1a220c70_at_posting.google.com>
Date: 28 Dec 2001 22:43:36 -0800
Message-ID: <bce41b15.0112282243.1a220c70_at_posting.google.com>
Raghu
Thanks for your reply, I got a little lost here may be you can clarify
You are suggesting that If we have a varchar2 type of size 1000 and
put just
1 character oracle optimizes it to 1 character size such that there is
no 999 penalty. Ok in that case why should I have 3 tables with <10
<20 <30 ( < less than) fields why dont I declare say 100 or whatever
columns of varchar and proceed with the solution of 1 table ( since
oracle anyhow does not wast space if we do not use). Am I missing
something. Please let me know.
I am working in USA.
Received on Sat Dec 29 2001 - 07:43:36 CET