Unanswered: impprove performance of "Insert into Select from.." query in sybase
I am a java developer with not much experience on db stored proc programming. I just wanted to know if "INSERT INTO(a,b) SELECT a,b FROM.." kind of sqls locks source table also for the time of execution, in sybase.
I am using one such sql where it insets huge data (may be 200-300k) in temp table for further processing. And it seems affecting other processes running in parallel.
Can we ensure in someway that "INSERT INTO(a,b) SELECT a,b FROM.." doesn't lock the source table...
Any help would be greatly appreciated. Thank you..