Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jfkuser
-
Hard disk recovery
Hi, I have two computers..one running with windows ME and one with Windows XP. My Windows ME computer is down . I took the hard disk from down computer and connected it to Windows XP computer thru hardware interface called 2.5" aluminium external enclosure which I got from COMPUSA. After...- jfkuser
- Thread
- Replies: 4
- Forum: PC hardware - Hard drive issues
-
Query optimization
Is there any way we can rewrite this query to run faster in DB2 7.2 : INSERT INTO SESSION.TEMP_CLMCNT03 ( SELECT TMP_CLM.CLM_ID ,MIN(TMP_CLM.CLM_CVRG_ID) ,TMP_CLM.PROC_DT FROM SESSION.TEMP_CLMCNT02 TMP_CLM WHERE... -
Query Optimization
We have a update on temp table which is running very slow on ver 7.2 .Here is the query. Is there anywat we can rewrite it to run faster? UPDATE SESSION.TEMP_AMOUNT02 TMP_AMT SET ( CLM_VAL ) = ( SELECT TMP_CVL.CLM_VAL FROM...
