Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Thumbs up Unanswered: [How do I...?] SELECT from a specific partition?

    If I have a table split up among partitions A, B, C, how do I select only from partition C?

    ~Le

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    To do that you would normally know the partition function definition, and use the values that you know would be stored in the corresponding partition.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •