Re: partitionning join table and normalization
Date: Wed, 9 Apr 2008 08:18:00 -0700 (PDT)
> 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