Re: SQL Newbie needs urgently help! [optimizing query]
Posted by:
Toxic Head
Date: January 24, 2007 05:52AM
btw.: the "select" of course without "explain" :-)
And here are the index columns:
Categories ->
Key_name Column_name Cardinality Index_type
PRIMARY PK 80610 BTREE
Categories_TypePKIndex TypePkString 2 BTREE
Categories_versionIDX p_catalogversion 25 BTREE
Categories_codeIDX p_code 26870 BTREE
Categories_codeVersionIDX p_code 26870 BTREE
Categories_codeVersionIDX p_catalogversion 80610 BTREE
Categories_extID p_externalid 80610 BTREE
Products ->
Key_name Column_name Cardinality Index_type
PRIMARY PK 852628 BTREE
Products_Product_Code Code 852628 BTREE
Products_TypePKIndex TypePkString 4 BTREE
Products_baseIDX p_baseproduct 852628 BTREE
Products_catalogIDX p_catalog 10 BTREE
Products_versionIDX p_catalogversion 18 BTREE
Products_visibilityIDX p_approvalstatus 1 BTREE
Products_visibilityIDX p_onlinedate 852628 BTREE
Products_visibilityIDX p_offlinedate 852628 BTREE
Products_codeVersionIDX Code 852628 BTREE
Products_codeVersionIDX p_catalogversion 852628 BTREE
Cat2ProdRel ->
Key_name Column_name Cardinality Index_type
PRIMARY PK 1406452 BTREE
Cat2ProdRel_LinkTarget TargetPK 703226 BTREE
Cat2ProdRel_TypePKIndex TypePkString 1 BTREE
Cat2ProdRel_LinkSource SourcePK 50230 BTREE
Cat2ProdRel_Qualifier Qualifier 1 BTREE
***
I hope the information is enough. If you need some more, don"t hesitate to ask for :-)
GreetZ Toxic
Subject
Views
Written By
Posted
3698
January 24, 2007 05:31AM
Re: SQL Newbie needs urgently help! [optimizing query]
2426
January 24, 2007 05:52AM
2307
January 24, 2007 06:07AM
2365
January 24, 2007 06:18AM
2221
January 24, 2007 06:41AM
2278
January 24, 2007 07:16AM
2334
January 24, 2007 08:16AM
2420
January 24, 2007 08:50AM
2238
January 24, 2007 09:10AM
2405
January 24, 2007 09:24AM
2528
January 24, 2007 10:29AM
2343
January 24, 2007 10:40AM
2236
January 24, 2007 03:19PM
2190
January 25, 2007 07:27AM
2275
January 24, 2007 07:16AM
2394
January 24, 2007 07:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.