Question : I have a development and production server, both with different amounts of RAM. Development machine has 8G, while […]
Tag: temporary-tables
Avoiding temporary tables while sorting by a column in a different table
Question : So I have this MySQL InnoDB query here: SELECT s.vid, s.body, s.timestamp, COUNT(v.id) AS votecnt FROM stories s […]
How does the optimizer treat yet-unpopulated #temp tables when estimating cardinality?
Question : I’ve been building stored procedures and can’t find any documentation on how the SQL Server optimizer handles #temp […]
MySQL – Can we use the same temporary table name in different stored procedure?
Question : In our database, we generate statistics by periodically calling a large number of stored procedures in the event. […]
When is mariadb creating tmp tables?
Question : I have found, that copying to tmp table is taking most of the time of a slow query, […]
What is the size of currently-existing tmp tables in innodb?
Question : This is yet another “how to add a column to a gigantic table” question. The table on disk […]
Automatically materialize CTE? (instead of temporary table CREATE and INSERT)
Question : I’m a novice trying to learn about query optimization and temporary tables in Oracle. The examples I’ve seen […]
When exactly are multiple users unable to simultaneously run a stored procedure with a temp table?
Question : I have a question regarding a piece of documentation on Temp Tables that I recently read on TechNet. […]
Statements in State “Copying to tmp table” disrupt performance [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
logical reads on global temp table, but not on session-level temp table
Question : Consider the following simple MCVE: SET STATISTICS IO, TIME OFF; USE tempdb; IF OBJECT_ID(N’tempdb..#t1′, N’U’) IS NOT NULL […]