Re: Cost-based Optimizers

Posted in 1994

"Beta Computers" — Sun, 2 Oct 1994 10:23:19 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, Its worth looking at the techie manuals for V6.* and above as these give a reasonable explanation of the costs / histograms that informix has in its optimiser, as far as I am aware this is just as powerful as Ingres's if not more so with various confidence levels the optimiser can see on the histograms of the data. Graham Twaddle Technical Director Beta Computers (Europe) Ltd beta@cix.compulink.co.uk A friend in need is usually on the net !