All Forums General
Purushotham 87 posts Joined 04/14
25 Jun 2014
Could anyone please tell me when Global temporary tables and VTT comes into picture in Real time.

 
Hi,
I have a query that when GTT and VTT comes into picture in realtime?
Could anyone please share me the knowledge that would helpful to me.
Thanks in advance.
Regards,
Purushotham.
 

Purushotham.M
Raja_KT 1246 posts Joined 07/09
25 Jun 2014

 

When you want to increase performance, like reducing spool space usage by queries, simplifying complex queries,reducing many joins.When you want to avoid denormalization. Anyway it is not part

of modeling........

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Purushotham 87 posts Joined 04/14
25 Jun 2014

Hi raja,

To reduce many joins,simplying complex queries and reducing spool usage by queries ,then temporary tables comes into picture,right?then what about derived tables raja.

Regards
Purushotham.M

Purushotham.M

Raja_KT 1246 posts Joined 07/09
25 Jun 2014

Think of few  scenarios say when you need statistics. Each and every object in DB has its own unique feature. We cannot integrate easily with derived tables when we have series of queries in one large business logic implementation when it has dependencies. Derived tables are not objects.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Purushotham 87 posts Joined 04/14
25 Jun 2014

Thank u raja...

Purushotham.M

You must sign in to leave a comment.