Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how can i find out which index is being used?

how can i find out which index is being used?

From: chaoping <zhuchaopku_at_263.net>
Date: Fri, 22 Dec 2000 13:43:05 +0800
Message-Id: <10717.125195@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C06C1D.1CA4D5F0
Content-Type: text/plain;

        charset="gb2312"
Content-Transfer-Encoding: base64

aGksYWxsDQogICAgb3VyIGFwcGxpY2F0aW9uIGlzIGEgbGFyZ2UgYy9zIHByb2dyYW0saGFzIG1p bGxpb25zIG9mIHBvd2VyYnVpbGRlciBjb2RlIGFuZCBvcmFjbGUgc3RvcmVkIHByb2NlZHVyZS5p dCBpcyBhbiBPTFRQIHN5c3RlbS4NCiAgICB0aGUgd29uZGVyIGlzIHRoYXQgd2UgYXJlIGhhdmlu ZyB0b28gbWFueSBpbmRleGVzLHRoZSBzaXplIG9mIGluZGV4ZXMgaXMgMS42IHRpbWUgdGhlIHNp emUgb2YgdGhlIGRhdGEub24gc29tZSB0YWJsZXMsdGhlcmUgaXMgYXMgbWFueSBhcyA2LTdpbmRl eGVzLiBhbmQgc28gaSB3b25kZXIgaWYgdGhlIGJlbmVmaXQgb2YgdXNpbmcgaW5kZXggd2hlbiBz ZWxlY3RpbmcgZGF0YSB3aWxsIGRlcHJlc3NlZCB3aGVuIG1haW50YWluaW5nIHRoZSBpbmRleGVz IHdoaWxlIERNTCB0aGUgZGF0YS4NCiAgICBhbmQgaSB3YW50IHRvIGZpbmQgb3V0IHdoaWNoIGlu ZGV4IGlzIGJlaW5nIHVzZWQsIGZyZXF1ZW50bHkgb3Igbm90LmFuZCBtYXliZSBpIHNob3VsZCBk cm9wIHNvbWUgdXNlbGVzcyBpbmRleGVzLg0KICAgIGNhbiBzb21lIG9uZSB0ZWxsIG1lIGhvdyB0 byBmaW5kIHRob3NlIGluZGV4ZXM/DQogICAgdGhhbmtzLg0K

------=_NextPart_000_001B_01C06C1D.1CA4D5F0
Content-Type: text/html;

        charset="gb2312"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWdi MjMxMiIgaHR0cC1lcXVpdj1Db250ZW50LVR5cGU+DQo8TUVUQSBjb250ZW50PSJNU0hUTUwgNS4w MC4yOTIwLjAiIG5hbWU9R0VORVJBVE9SPg0KPFNUWUxFPjwvU1RZTEU+DQo8L0hFQUQ+DQo8Qk9E WSBiZ0NvbG9yPSNmZmZmZmY+DQo8RElWPjxGT05UIHNpemU9Mj5oaSxhbGw8L0ZPTlQ+PC9ESVY+ DQo8RElWPjxGT05UIHNpemU9Mj4mbmJzcDsmbmJzcDsmbmJzcDsgb3VyIGFwcGxpY2F0aW9uIGlz IGEgbGFyZ2UgYy9zIHByb2dyYW0saGFzIA0KbWlsbGlvbnMgb2YgcG93ZXJidWlsZGVyIGNvZGUg YW5kIG9yYWNsZSBzdG9yZWQgcHJvY2VkdXJlLml0IGlzIGFuIE9MVFAgDQpzeXN0ZW0uPC9GT05U PjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IHRoZSB3b25kZXIg aXMgdGhhdCB3ZSBhcmUgaGF2aW5nIHRvbyBtYW55IA0KaW5kZXhlcyx0aGUgc2l6ZSBvZiBpbmRl eGVzIGlzIDEuNiB0aW1lIHRoZSBzaXplIG9mIHRoZSBkYXRhLm9uIHNvbWUgDQp0YWJsZXMsdGhl cmUgaXMgYXMgbWFueSBhcyA2LTdpbmRleGVzLiBhbmQgc28gaSB3b25kZXIgaWYgdGhlIGJlbmVm aXQgb2YgdXNpbmcgDQppbmRleCB3aGVuIHNlbGVjdGluZyBkYXRhIHdpbGwgZGVwcmVzc2VkIHdo ZW4gbWFpbnRhaW5pbmcgdGhlIGluZGV4ZXMgd2hpbGUgRE1MIA0KdGhlIGRhdGEuPC9GT05UPjwv RElWPg0KPERJVj48Rk9OVCBzaXplPTI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IGFuZCBpIHdhbnQgdG8g ZmluZCBvdXQgd2hpY2ggaW5kZXggaXMgYmVpbmcgDQp1c2VkLCBmcmVxdWVudGx5IG9yIG5vdC5h bmQgbWF5YmUgaSBzaG91bGQgZHJvcCBzb21lIHVzZWxlc3MgDQppbmRleGVzLjwvRk9OVD48L0RJ Vj4NCjxESVY+PEZPTlQgc2l6ZT0yPiZuYnNwOyZuYnNwOyZuYnNwOyBjYW4gc29tZSBvbmUgdGVs bCBtZSBob3cgdG8gZmluZCB0aG9zZSANCmluZGV4ZXM/PC9GT05UPjwvRElWPg0KPERJVj48Rk9O VCBzaXplPTI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IHRoYW5rcy48L0ZPTlQ+PC9ESVY+PC9CT0RZPjwv SFRNTD4NCg==

------=_NextPart_000_001B_01C06C1D.1CA4D5F0--
Received on Thu Dec 21 2000 - 23:43:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US