Re: partitionning join table and normalization
From: <chmanu_at_gmail.com>
Date: Wed, 9 Apr 2008 08:18:00 -0700 (PDT)
Message-ID: <73a5abc4-2a0f-42f7-91e0-756d70d01fe5@k10g2000prm.googlegroups.com>
Date: Wed, 9 Apr 2008 08:18:00 -0700 (PDT)
Message-ID: <73a5abc4-2a0f-42f7-91e0-756d70d01fe5@k10g2000prm.googlegroups.com>
> 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