Re: Simpler Join: Komplette Tabelle wird gescannt
NOT IN ist eingebaut und der ausgebaute GROUP BY wirkt bisher wirklich so, als wenn der Query tut, was er soll, weitere Tests stehen aber noch an.
Zu den Buffer-Einstellungen:
Variable_name Value
bulk_insert_buffer_size 8388608
innodb_buffer_pool_size 8388608
innodb_log_buffer_size 1048576
join_buffer_size 131072
key_buffer_size 8384512
myisam_sort_buffer_size 8388608
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 131072
read_rnd_buffer_size 262144
sort_buffer_size 2097144
sql_buffer_result OFF
Subject
Views
Written By
Posted
1909
December 15, 2012 02:12PM
1056
December 15, 2012 02:55PM
1020
December 15, 2012 03:09PM
1022
December 15, 2012 07:30PM
1127
December 16, 2012 02:32AM
952
December 16, 2012 02:41AM
856
December 22, 2012 09:02AM
1090
December 22, 2012 09:29AM
862
December 22, 2012 09:46AM
954
December 22, 2012 10:28AM
932
December 22, 2012 10:53AM
Re: Simpler Join: Komplette Tabelle wird gescannt
1213
December 22, 2012 11:05AM
1380
December 22, 2012 11:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.