Home » SQL & PL/SQL » SQL & PL/SQL » CBO (oracle 11g / unix)
CBO [message #617840] Thu, 03 July 2014 22:51 Go to next message
balaji123
Messages: 29
Registered: October 2009
Location: sanfrancisco
Junior Member
This question is related to CBO ( Cost based optimizer)

select a.*,b.* from a,b
where a.emp_no = b.emp_no +0
and a.dept_no = b.dept_no + 0
and a.sal > 3000 OR a.sal > 5000

toad optimizer suggested to use + 0 on sql where condition.
Please advise. +0 means ignoring index ?

Thanks in advance.

Report message to a moderator

Previous Topic: Parse XML to Oracle Database
Next Topic: SYS_CONNECT_BY_PATH
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 21:29:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.