meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 8 months |
| seen | May 7 at 14:43 | |
| stats | profile views | 3 |
|
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? |
