-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|