Re: Table Variable vs Temporary Table

From: Adi (adico_at_clalit.org.il)
Date: 11/24/04

Next message: Alejandro Mesa: "RE: How to force a deadlock"
Previous message: Marc Mertens: "Re: Security and Views"
In reply to: CB: "Table Variable vs Temporary Table"
Next in thread: Yoshi: "Re: Table Variable vs Temporary Table"
Messages sorted by: [ date ] [ thread ]

Date: 24 Nov 2004 06:57:51 -0800

AFAIK one of the main difference between temporary table and table
variable is that there are no statistics for table variable but there
are statistics for temporary table. The lack of statistics for the
table variable might cause the performance difference.

Adi

Next message: Alejandro Mesa: "RE: How to force a deadlock"
Previous message: Marc Mertens: "Re: Security and Views"
In reply to: CB: "Table Variable vs Temporary Table"
Next in thread: Yoshi: "Re: Table Variable vs Temporary Table"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: connect() returns EADDRINUSE during massive host->host conn rate
... which does repeated connections to the specified address, ... transactions and computes some statistics). ... AFAIK this behaviour was ...
(freebsd-stable)
Re: Julie Kirkbride to stand down
... AFAIK they are all allowed a free ... postal service to send a leaflet to everybody on the voter's roll. ... UPS/FUNTO April stats: http://homepage.ntlworld.com/my.web.pages/stats/ ... Over six years' statistics now available. ...
(uk.people.silversurfers)
Re: K of what?
... bits - AFAIK all transmission speeds are in bits per second - and includes ... UPS/FUNTO August stats: http://my-web-pages.110mb.com/stats/ ... Five years' statistics now available. ...
(uk.people.silversurfers)