Re: Hash and Linear Hash partition table not performing well

[Neeraj Khandelwal]

Thanks!

I'm using 128 partitions and using simple queries with IN clause and passing the # of arguments... in order
1. 10
2. 50
3. 100
4. 500
5. 1000
6. 2500
7. 5000
8. 10000
9. 50000
10. 100000
11. 500000
12. 1000000

SQL Exa: SELECT COUNT(*) FROM test_data WHERE id IN(.........);

Thanks in advance!