| Hints index combine [message #212886] |
Mon, 08 January 2007 14:18  |
uicmxz
Messages: 48
Registered: July 2006
|
Member |
|
|
I tried to analyzed query that was running a full table scan on t1 table. I use hins index-combine that converts bitmap index to rowid.
This query was not running a full table scan anymore, but the cost of query is increased.
Is this makes any affects on performance or on other precesses?
|
|
|
|
| Re: Hints index combine [message #212920 is a reply to message #212886] |
Mon, 08 January 2007 17:37  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> Is this makes any affects on performance or on other precesses?
You hinted only the query you wanted to fix. Right?
Then, it will not affect other process.
>>but the cost of query is increased
What about response time?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
