"Zabach, Elke" wrote: > Hey, keep cool, perhaps take a breath of fresh air outside your office. > To use the word MORONIC is not the way we should talk with each other.
Sorry if I offended someone, that we most definatly not my intention, I was refering that single decision made by the optimizer, not the fine people who wrote it or any other part of sapdb. > But we just walk along the index and check for this search condition. > We do not sort first, store the sorted result and then start to check. > Did you think this???? That's what I thought, the "moronic" about that was that I have quite selective indices on the three columns in the search condition... I guess this is caused by my non-mainstream usage of IN and/or lacking statistics for the optimizer to chew on. > What do you think (after some fresh air / a cup of coffee) about the > database? I think, as I always have, that sapdb is a fine database and a beautiful and wonderful gift. ... even if I have spent quite a while over the last year or two getting bitten by and debugging various bugs in it :-D -- Regards Flemming Frandsen aka. Dion/Swamp http://dion.swamp.dk _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
