On 7/13/06, Christian Rengstl <Christian.Rengstl@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Good morning list, the following query takes about 15 to 20 minutes for around 2 million lines in the file myfile.txt, but with 8 million lines it takes around 5 hours and i just don't understand why there is such a huge discrepancy in performance.
on the surface it doesn't make sense, can you post an explain analyze? merlin
