Re: partitionning join table and normalization

From: <>
Date: Wed, 9 Apr 2008 08:18:00 -0700 (PDT)
Message-ID: <>

> The problem appear when i want to use a view which not including the
> condition on id.
> If this problem can be solves, what about my initial question :
> Is it possible to create a partitionnal table on fields coming from a
> join table ?

I've solved the problem and use a classic table (not iot). The cost and the respond time are correct (6 with the join to TD and < 200ms), partitionning is perhaps not important (test with about 5M rows but all of them are null).

Chmanu Received on Wed Apr 09 2008 - 10:18:00 CDT

Original text of this message