-
Expert Member
Query Performance
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
-
Re: Query Performance
How you use the first one ?
-
Expert Member
Re: Query Performance
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.
-
Re: Query Performance
You mean to say ,you are compairing after string concatination ?
-
Expert Member
Re: Query Performance
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules