Re: O9i: general index question

Hi ng,

I found a solution:

I should have analyzed my table for all indexed colums. In that case the cbo finds out that only 1% of the data is asked for and it uses many indexes.
My query now needs less than 1 sec.

@Thorsten: I do not know my mistake but second try with NULL- values solved the problem too. This time I still do not know, whether I step to NULL- values or keep on '0000000000'. I think next time I will keep '00..' and next version I turn to NULL to save storage.

Special thanks to sybrand and Thorsten. You helped me a lot.

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de