| NEED HELP TUNING SQL [message #10289] |
Tue, 13 January 2004 05:53 |
Kuldeep
Messages: 21
Registered: June 2002
|
Junior Member |
|
|
SELECT "SKU" ,"MODEL" ,"DESCRIPTION" ,"FULL_DESCRIPTION" ,"UPC" ,"CAT_NO" , "SUBCAT" ,"VENDOR_NO" ,"BRAND" ,"DLR_PRC" ,"RET_PRC" ,"LIST_PRC" , "VNDR_UNIT" ,"WEB_PRICE" ,"REPL_COST" ,"AVER_COST" ,"LANDED_COST" , "SERIALS" ,"TAXED" ,"COMMISSIONED" ,"ESP_ITEM" ,"BASE_ESP" ,"STATUS" , "CMNT" ,"CLASS" ,"DESC2" ,"BACKORDER" ,"PRODUCT_CODE" ,"COLOR" , "FORCED_SHIP_VIA" ,"INCLUDES_DEL_CHARGE" ,"ROWID"
FROM
"LOOKUP"."INVENTORY" ORDER BY "SKU" ASC
I Have a unique index on SKU and another on Model and I have a non-unique index for Description. However, this query is doing a heavy disk read. Here is the explain plan and some stats. I tried to create an index on SKU and MODEL, but the query does not like it. Also, when I add a hint to the query to use the index, it does not like it and the cost does not go down.
This is creating havoc for us here. Any help or suggestions would be greatly appreciated.
Sincerely,
Kuldeep
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
