Total Cost Avg IDX Query -------- -------- -------- --- -------> 138.780 5.140 5.140 IDX select description from products where sku = '142-1007' 138.780 5.140 5.140 IDX select sale_price from products where sku = '142-1007' 143.920 5.140 5.140 IDX select sale_price from products where sku = '140-1028' 143.920 5.140 5.140 IDX select thumb from products where sku = '00024' 143.920 5.140 5.140 IDX select sku from products where sku = '142-1009' 143.920 5.140 5.140 IDX select option_type from products where sku = '140-1028' 149.060 5.140 5.140 IDX select gift_cert from products where sku = '140-1028' 154.700 5.950 5.950 IDX select * from options where code = '142-1007' 154.700 5.950 5.950 IDX select * from options where code = '112-9083' 154.700 5.950 5.950 IDX select * from options where code = '140-1028' 164.480 5.140 5.140 IDX select description from products where sku = '140-1028' 185.040 5.140 5.140 IDX select sku from products where sku = '142-1011' 231.300 5.140 5.140 IDX select sku from products where sku = '142-1035' 233.100 3.150 3.150 IDX SELECT o_group,price FROM options where sku = '142-1035' and price != '' 233.100 3.150 3.150 IDX SELECT o_group,price FROM options where sku = '142-1030' and price != '' 246.720 5.140 5.140 IDX select sku from products where sku = 'gift-cert' 267.280 5.140 5.140 IDX select thumb from products where sku = '112-9083' 267.280 5.140 5.140 IDX select thumb from products where sku = '140-1028' 267.280 5.140 5.140 IDX select thumb from products where sku = '142-1007' 287.840 5.140 5.140 IDX select sku from products where sku = '00024' 292.830 97.610 97.610 SEQ select * from products