DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: partitioned tables

  1. #1
    Join Date
    Sep 2001
    Posts
    4
    In Oracle8i range paritioned table, I want to make queries without hardcoding the partition name. But I want to get the benefit of faster access by the partitioned table.
    Is it possible? Please help.

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    you can always use view instead of the actual partioned table.
    And since the underlying table is partitioned, then your view should be much faster compare to regular views.

    Hope that helps.

  3. #3
    Join Date
    Sep 2001
    Posts
    4
    Hi reydb,

    Thanks for your reply. If possible give an example for this. Is there anyother way?

    Thanks

    Murali

  4. #4
    Join Date
    Oct 2001
    Location
    Pelham, AL
    Posts
    40

    Arrow

    To answer your first question, yes, if your queries "prune" the data according to the way the table is partitioned, you will still get faster performance whether or not you specify the partition name in the queries.

    Also, if you have setup the server and table for parallel query, you will get faster performance even on a full scan, because the several partitions can be scanned, concurrently.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you dont have to hardcode the partition name to use partitioning advantages, if that was the case (hardcoding partition name in application) then I doubt many people would use this feature.
    Oracle's optimizer is clever enough to use this feature without partition name, let's say you have 3 partitions with 3 values in each, (1,2,3 4,5,6 7,8,9) if your select says

    where X = 3 oracle will do a partition elimination, it will read the first partition only not all of them

Posting Permissions

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


Click Here to Expand Forum to Full Width