| Cost based Optimizer built access paths [message #113959] |
Fri, 12 September 2003 10:01  |
Carol Cloyed
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
We have a 64Million row table with an idex that has 63 unique values for an index. The rows are spread fairly evenly across 30 partitions.
The issue we are trying to solve is how to make adjustments to cause the CBO to select an index access path when selection a single value in the index but continue to select a tablespace scan in all other circumstances.
FYI. An INDEX hint does give the desired results but we are searching for a system control that will automate the process.
Does anyone have any experience with this type of situation?
Thanks for any recommendation you may have.
Carol
|
|
|
|
| Re: Cost based Optimizer built access paths [message #113960 is a reply to message #113959] |
Tue, 23 September 2003 08:07  |
Subhash Roy
Messages: 24
Registered: January 2001
|
Junior Member |
|
|
: We have a 64Million row table with an idex that has 63 unique values for an index. The rows are spread fairly evenly across 30 partitions.
: The issue we are trying to solve is how to make adjustments to cause the CBO to select an index access path when selection a single value in the index but continue to select a tablespace scan in all other circumstances.
: FYI. An INDEX hint does give the desired results but we are searching for a system control that will automate the process.
: Does anyone have any experience with this type of situation?
: Thanks for any recommendation you may have.
: Carol
: Is the index also partitioned? Did you include the partion key in addition to the index key in the WHERE cluase? I read some documents in the Metalink, but never played it in our enviroment as we are still on the 7.3.3 version. It sounds line you are running 8i or 9i. I think the documents in the Metalink may help you solve your case.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
