![]() |
Can anyone please explain difference between Common Table Expression(CTE)Tables and Volatile tables in which scenario they perform better.
29 Apr 2016
| 4 comments
,
|
![]() |
Hello,
23 Apr 2016
| 2 comments
,
|
![]() |
Hello, I am connected in SQL Assistant, and run a SP who believes, this SP uses a volatile table. I need to know how to remove the TV from the SP. Without having to disconnect from the session.
23 Apr 2013
| 4 comments
,
|
![]() |
When you create a VOLATILE TABLE what location is it created in? I know it is a temp table that is gone when the session ends. The following SQL will give me the SQL that was used to create the table:
06 Jul 2011
| 7 comments
,
|
![]() |
In which scenarios we use Volatile tables and Global
03 Dec 2010
| 9 comments
,
|
![]() |
We are using the PooledConnections using V13 versions of the JDBC driver and have noticed that the volatile tables seem to stay even when we call the close method on the connection. E.g. But if we do
25 Oct 2010
| 1 comment
,
|
![]() |
I have SQL that needs to run some preprocessing creating a volatile table to be exported to a file. If I use a setup step TPT is using a different session for each step and the volatile table goes away. Anyone have a work around?
31 Aug 2010
| 3 comments
,
|