Hi!
I have 4 question which probably someone can answer. 1) I have a transaction during which no data was modified, does it make a difference whether i send COMMIT or ROLLBACK? The effect is the same, but what�s about the speed? 2) Is there any general rule when the GEQO will start using an index? Does he consider the number of tuples in the table or the number of data pages? Or is it even more complex even if you don�t tweak the cost setting for the GEQO? 3) Makes it sense to add a index to a table used for logging? I mean the table can grow rather large due to many INSERTs, but is also seldom queried. Does the index slowdown noticable INSERTs? 4) Temporary tables will always be rather slow as they can�t gain from ANALYZE runs, correct? Thanx in advance for any answer Christoph Nelles -- Mit freundlichen Gr�ssen Evil Azrael mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
