Re: Data Modeling Question

Ahbaid,

If you haven't done so, go through the mandatory introduction to 'How to get dreadful database performance' by Stephane Faroult. You can find it here

I'm serious. It is really, really worth your time. If you can't spare 20 minutes, then go through the first 5 minutes at least.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Wed, 2008-02-06 at 19:51 -0800, Ahbaid Gaffoor wrote:

> We have a data model which looks like the following:
>
> ITEMS
> ==========
> ITEM_CODE VARCHAR2(100) (Primary Key col 1)
> ITEM_TYPE VARCHAR2(100)
> ATTRIBUTE_001 VARCHAR2(4000)
> ATTRIBUTE_002 VARCHAR2(4000)
> ...
> ATTRIBUTE_250 VARCHAR2(4000)
>
>
> ITEM_TYPE_LU
> ============
> ITEM_TYPE VARCHAR2(100) (Primary Key col 1)
> ATTRIBUTE_NAME VARCHAR2(1000) (Primary Key col 2)
> ATTRIBUTE_COLNUM NUMBER
>
> I am proceeding with approach 1 for now.
>
> many thanks for your input
>
> Ahbaid
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l