Re: Tetra and Update Statistics

Mark D. Stock wrote: > > I don't think it will ignore a direct unique key filter, and will > assume a row count of one. I don't think UPDATE STATS will affect the > use of an index for single key values, it does for multiple key > values, storing something like the 2nd min & max values for a LOW, > and obviously data distribution details for a MEDIUM and HIGH. I've > not seen problems hitting an index in Baan for example. Ahh good call. of course. No need for stats if u have all the fields of a unique index. Just probe the index; you get a row or you don't. As for the BAAN explanation - fair enough then. Scary stuff.