Rattler1887
Last Activity: Jun 7 '12, 06:23 PM
Joined: Jun 6 '12
Location:
-
Thank Rabbit, I appreciate your time. I am going to have to get the DBA to create an index for me and you are correct in that the wild card run's faster than the substr. I timed them both and the wild card cut off about 15 minutes...but overall time is still not acceptable. -
Thanks Rabbit. My original where clause is comparing to fields. When I changed the statement to use wild card it was for a specific case number..., i.e.
[WHERE A.FIELD LIKE '%1999AP000198A XX%'] I guess my statement would be [WHERE A.FIELD LIKE B.FIELD]...Leave a comment:
-
I don't think the wildcard is going to help me out, I changed it and it's still running...It's been running for the last 12 minutes...Leave a comment:
-
Performance Issue when substr used in where clause
After researching a problem with a report I found that the fields used in the where clause did not equal because of some data conversion done on one of the tables. During the conversion one of the fields was prefixed with "50".
So now A.Field does not equal B.Field.
So I decided that I would add "WHERE substr(A.Field, 3,15) = B.Field". The system timed out on me.
I read in another forum to...
No activity results to display
Leave a comment: