hi
i m using sql serever 2005 management express to excecute my queries in ssms but it seems query execution is very slow it takes 2000 to 3000 millisecond to excute 22000 records (with 39 columns) for select query following is my query please tell me where
i have making mistake
SELECT Product.ProductID, Product.ProductName, Product.UOM, Product.ExpDate,
Product.CreationDate, Product.LastUpdate, Product.Location, Product.OpeningQty,
Product.Manufacturer, Product.MFGCode, Product.Packing, Product.UnitCost,
Product.CompanyPrice, Product.TradePrice, Product.SalesPrice, Product.[Group],
Product.OpeningDate, Product.Supplier, Product.MinQty, Product.MaxQty, Product.ReOrderLevel,
Product.BNo, Product.QtyOut, Product.GroupID, Product.SupplierID, Product.LastSalesDate,
Product.LastPurchaseDate, Product.StoreID, Product.Photo, Product.ProgramID, Product.DealerPrice,
Product.TPDisc, Product.WholesalePrice, Product.OpeningUC, Product.ImagePath, Product.ShowVal,
CASE WHEN StockBalances.QtyBalance IS NULL THEN 0 ELSE StockBalances.QTYBALANCE END AS QtyBalance,
Product.Active FROM Product LEFT OUTER JOIN StockBalances ON Product.ProductID = StockBalances.ProductID
WHERE (Product.Active = 1)
