Home » RDBMS Server » Performance Tuning » Hints index combine
Hints index combine [message #212886] Mon, 08 January 2007 14:18 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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?
Previous Topic: Parallel queries.
Next Topic: At specific table size i'm seeing a 10x increase in query time
Goto Forum:
  


Current Time: Mon Dec 05 21:08:26 CST 2016

Total time taken to generate the page: 0.09883 seconds