131 reputation
3
bio website
location
age
visits member for 2 years, 1 month
seen May 7 '13 at 14:43

May
7
awarded  Supporter
Sep
12
revised Is it worth partitioning a Table by single value in Oracle?
added 124 characters in body
Sep
12
comment Is it worth partitioning a Table by single value in Oracle?
see the edit please
Sep
12
revised Is it worth partitioning a Table by single value in Oracle?
added query plans
Sep
11
comment Is it worth partitioning a Table by single value in Oracle?
Thanks, I've done a little test here with 1M rows: 500348 with TENANTID=2, 499652 with TENANTID=1 randomly distributed and, according to the QUERY PLAN, partitioned table has smaller cost (1112 vs 1521) compared to bitmap indexed one. How would you explain it?
Sep
6
awarded  Editor
Sep
6
revised Is it worth partitioning a Table by single value in Oracle?
removed unnecessary code
Sep
5
awarded  Student
Sep
5
asked Is it worth partitioning a Table by single value in Oracle?