1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Partition(dailyp********)

Discussion in 'General' started by ketangarg86, May 13, 2015.

  1. ketangarg86

    ketangarg86 Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I am running stats on a table which is partitioned. Current I use the below query:

    select * from testing partition(dailyp20150514)

    It is possible I can run the above query for the whole month dynamically. Maybe put sysdate somewhere as it would make it dynamic.

    The "testing" table does has a time but running again the time column takes a lot of time and also I don't want to include the weekends (Fri, Sat)

    Could you please help.