How to tune query in a large partition table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to tune query in a large partition table

  1. #1
    Join Date
    Sep 2009
    Posts
    6

    How to tune query in a large partition table

    Hi,
    I am having a partition table having a large size. I have to tune queries to fetch data from the table. The details are as follows:
    1. Table is having 10 cr data in each partition and avg. rowsize is 167.
    2. Currently there are 40 partitions and only 3 partitions are loaded with data.
    3. Total no of columns in the table is : 52
    4. The partition table I had creted as composite partition i.e partition is in the date field and in each partition is having 8 hash partitions.
    5. The data is loaded in the table by SQL* Loader.

    Actually I had created one local index in the partition table to fetch the data faster, but due to the index the loading was very slow , so I had to drop the index.

    Can you please help me what is the best way that I can fetch data from the table easily?

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Rebuild index after ETL.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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