Newbie - Partition setup multiple tables

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Justin

    Newbie - Partition setup multiple tables

    We have a table that is growing quickly and would like to partition it
    by date. However, the table does not have a date field. With another
    table, we are able to create a link to bring in the date.

    Is it possible to create a table that is partitioned by date from a
    field in a different table?

    Hope that is clear.

    -JB
  • Ian

    #2
    Re: Newbie - Partition setup multiple tables

    Justin wrote:
    We have a table that is growing quickly and would like to partition it
    by date. However, the table does not have a date field. With another
    table, we are able to create a link to bring in the date.
    >
    Is it possible to create a table that is partitioned by date from a
    field in a different table?
    No, you have to use a column in the physical table.

    Comment

    Working...