October 4, 2013 at 1:20 pm
I have query but it takes 10 min to update all the routes any one how to optimized it
update cwlocal.adhoc_route a
set route_id = (select trim(route_no)
from cwlocal.routes b
where b.trip_no = a.trip_number)
where EXISTS
(select 1 from cwlocal.routes b where b.trip_no = a.trip_number)
and to_char(a.filename_date,'yyyyMMdd') = ?
Regards
Shaun
October 4, 2013 at 1:28 pm
Shaun2012 (10/4/2013)
I have query but it takes 10 min to update all the routes any one how to optimized itupdate cwlocal.adhoc_route a
set route_id = (select trim(route_no)
from cwlocal.routes b
where b.trip_no = a.trip_number)
where EXISTS
(select 1 from cwlocal.routes b where b.trip_no = a.trip_number)
and to_char(a.filename_date,'yyyyMMdd') = ?
Regards
Shaun
I assume you must be running this on the Oracle side of your process. There are some people around here with extensive Oracle knowledge but most of us are sql server folks and are more likely to steer you wrong than right.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply