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
Printable View
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
How you use the first one ?
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.
You mean to say ,you are compairing after string concatination ?
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