Sebastian Böck <sebastianboeck@xxxxxxxxxx> schrieb: > Hello, > > I get unpredictibale results selecting from a view depending on > index-usage. > [ snipp ] > > SELECT * from test WHERE type = 'a'; unfortunately, no result. What Du you expect? Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings