Bookmark lookup (Why)

From: we7313 (we7313_at_discussions.microsoft.com)
Date: 12/15/04

  • Next message: Hugo Kornelis: "Re: Bookmark lookup (Why)" 
    Date: Wed, 15 Dec 2004 11:55:04 -0800

    I can't figure out why i have a bookmark lookup cost on ValidVendorPackages
    on the below proc:

    Select PriceViewHotelPrice.price as Totalprice, PriceViewHotelPrice.Docid
    from price_view PriceViewHotelPrice Inner Join
            (
            select C1.Priceid as Pid,C1.VendorPackageId from
                    (
                    select distinct(HA.PriceId), HA.VendorPackageId from Criteria HA Inner Join
                            (
                                    select VendorPackageId from ValidVendorPackages
                                    where (Vendor = @Vendor or @Vendor = '')
                                    and (Sitecode = @Sitecode or @Sitecode = '')
                                    and (PackageType = @PackageType or @PackageType = '')
                                    and (RequiredItems = @RequiredItems or @RequiredItems = -1)
                            )HB on HA.VendorPackageId = HB.VendorPackageId
                            and
                            (
                            CriteriaId in
                            (
                            select CriteriaID from ValidItemCriteria
                            where Destination = @Destination
                            and LengthOfStay = @LengthOfStay
                            and Ages = @Ages
                            and ComponentType = 'H'
                            and (ValidItemType = @HotelValidItemType_1 or @HotelValidItemType_1 = '' )
                            and (ItemValue = @HotelItemValue_1 or @HotelItemValue_1 = '' )
                            )
                            )
                    ) C1
                    ) HotelCriteriaPriceId on PriceViewHotelPrice.priceid =
    HotelCriteriaPriceId.Pid
                    and PriceViewHotelPrice.keydate between @KeyDateMin and @KeyDateMax
                    and ((PriceViewHotelPrice.price) between @PriceLow and @PriceHigh or
    @PriceLow = -1)
                    and (PriceViewHotelPrice.Volatility between @VolatilityMin and
    @VolatilityMax or @VolatilityMin = -1)
                    and (PriceViewHotelPrice.AvgMinsUpdateInterval between
    @AvgMinsUpdateIntervalMin and @AvgMinsUpdateIntervalMax or
    @AvgMinsUpdateIntervalMin = -1)
                    Order by TotalPrice

    can anyone see why? 

    -- 
will
  • Next message: Hugo Kornelis: "Re: Bookmark lookup (Why)"