sql - Oracle multiple partition selection -


I have a query that selects from multiple partitions

  select * table Select * from Partition (P1), Table 2, Table 3, Table 4 Associations * All tables * Partition (P2), Table 2, Table 3, Table 4. * Select from Table Partition (P12), Table 2, Table 3, Table 4 *  

There are 30,331,246 entries in 12 sections in the table. To draw the result, I need to find a fast way (now it takes about 35 minutes) If I do not select from the table, the part of the partition will be more than 135min, but it is not what a query should look like.

Can you help me find another way to do this?


Comments

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -