Query Performance

[krishnaindia2007]

Performance wise is there any difference between the following two?

where a.x||a.y||a.z = b.x ||b.y||b.z

and

where a.x = b.x
and a.y = b.y
and a.z = b.z

[debasisdas]

How you use the first one ?

[krishnaindia2007]

Columns are of Vachar2 type. I used first type of query for generating four reports. It is working but s taking considerable time for generating output.

[debasisdas]

You mean to say ,you are compairing after string concatination ?

[susarlasireesha]

query performance point of u where 'a.x = b.x
and a.y = b.y
and a.z = b.z '
is better than 'where a.x||a.y||a.z = b.x ||b.y||b.z'
becasue || some times disables indexing