Re: Data Modeling Question
- From: Carel-Jan Engel <careljan@xxxxxxxxxx>
- To: ahbaid@xxxxxxx
- Date: Thu, 07 Feb 2008 09:05:29 +0100
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
>
>
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
Other related posts:
