Received: (qmail 19292 invoked from network); 7 Jul 2009 09:21:50 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 7 Jul 2009 09:21:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 42BF7C7EE1B; Tue, 7 Jul 2009 10:21:29 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 3jhOQ7z6Sqt7; Tue, 7 Jul 2009 10:21:29 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B6DA7C7EE00; Tue, 7 Jul 2009 10:21:28 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 07 Jul 2009 10:19:10 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A2370C7ECCB; Tue, 7 Jul 2009 10:19:10 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LKCQQ6q4QbhD; Tue, 7 Jul 2009 10:19:10 -0400 (EDT) Received: from VA3EHSOBE001.bigfish.com (va3ehsobe001.messaging.microsoft.com [216.32.180.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74FA0C7EC9D; Tue, 7 Jul 2009 10:19:07 -0400 (EDT) Received: from mail120-va3-R.bigfish.com (10.7.14.243) by VA3EHSOBE001.bigfish.com (10.7.40.21) with Microsoft SMTP Server id 8.1.340.0; Tue, 7 Jul 2009 14:19:02 +0000 Received: from mail120-va3 (localhost.localdomain [127.0.0.1]) by mail120-va3-R.bigfish.com (Postfix) with ESMTP id D667C21824B; Tue, 7 Jul 2009 14:19:02 +0000 (UTC) X-SpamScore: -34 X-BigFish: VPS-34(zz542N1432R936eM1805M9371Pzz1202hzzz2fh6bh61h) X-Spam-TCS-SCL: 0:0 X-FB-SS: 5, Received: by mail120-va3 (MessageSwitch) id 1246976341353344_22465; Tue, 7 Jul 2009 14:19:01 +0000 (UCT) Received: from dsmtpg02.col.discoverfinancial.com (dsmtpg02.col.discoverfinancial.com [12.41.53.16]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mail120-va3.bigfish.com (Postfix) with ESMTP id 411B4A5004C; Tue, 7 Jul 2009 14:19:01 +0000 (UTC) Received: from dsmtpg02.col.discoverfinancial.com ([12.41.53.10]) by dsmtpg02.co.discoverfinancial.com with ESMTP id n67E2M9569488; Tue, 7 Jul 2009 10:02:22 -0400 Received: from dfscolm02.co.discoverfinancial.com (dfscolm02.co.discoverfinancial.com [199.12.96.170]) by dsmtpg02.co.discoverfinancial.com with ESMTP id n67E0xZ569364; Tue, 7 Jul 2009 10:00:59 -0400 In-Reply-To: <81ED609A5D964A67843C7212D39E0AF6@Primary> Subject: Re: create_index_cost procedure To: jonathan@jlcomp.demon.co.uk CC: oracle-l@freelists.org, oracle-l-bounce@freelists.org Message-ID: From: Date: Tue, 7 Jul 2009 09:05:35 -0500 X-MIMETrack: Serialize by Router on DFSCOLM02/MSRV/DFSI(Release 7.0.3|September 26, 2007) at 07/07/2009 09:05:37 MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 X-CFilter-Loop: Reflected X-archive-position: 19139 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: genegurevich@discover.com Precedence: normal Reply-to: genegurevich@discover.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l Sm9uYXRoYW46DQoNCk5vdyB0aGF0IEkgaGF2ZSByZXJlYWQgeW91ciBhcnRpY2xlLCBJIHRoaW5r IG15IHF1ZXN0aW9uIGlzIHRoZSBzYW1lIGFzIHlvdQ0KcmFpc2VkOg0KIiAyNCwwMDAgYnl0ZXMg YXMgdGhlIHVzZWQgYnl0ZXMg4oCTIGFuZCB0aGF0IHNob3VsZCBmaXQgY29tZm9ydGFibHkgaW5z aWRlIGENCnNpbmdsZSA2NEtCIGV4dGVudCBpbiB0aGUgc3lzdGVtdGFibGVzcGFjZSDigJMgc28g d2h5IHdhcyB0aGUgYWxsb2NhdGVkIHNwYWNlDQpyZXBvcnRlZCBhcyAxMjhLQiAvIHR3byBleHRl bnRzPzoNCg0KQW5kIHlvdXIgYW5zd2VyIHNlZW1zIHRvIGJlIHRoYXQgdGhpcyBudW1iZXIgZG9l cyBub3QgaW5jbHVkZSB0aGUgdmFyaW91cw0Kb3ZlcmhlYWRzIGFzIHdlbGwgYXMgb3RoZXIgZmFj dG9ycyB0aGF0IGNvdWxkIGFmZmVjdCB0aGUgc2l6ZS4NCkRvZXMgdGhhdCBtZWFuIHRoYXQgaXQg aXMgYWxsb2NhdGVkIGJ5dGVzIHRoYXQgc2hvdWxkIGJlIGNvbnNpZGVyZWQgYSByb3VnaA0KZXN0 aW1hdGUgaW4geW91ciBvcGluaW9uPw0KDQp0aGFuayB5b3UNCg0KR2VuZSBHdXJldmljaA0KDQoN Cg0KDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAiSm9uYXRoYW4gTGV3aXMiICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAg IDxqb25hdGhhbkBqbGNvbXAuICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgDQogICAgICAgICAgICAgZGVtb24uY28udWs+ICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBUbyANCiAgICAgICAgICAgICBTZW50IGJ5OiAgICAgICAg ICAgICAgICAgIDxvcmFjbGUtbEBmcmVlbGlzdHMub3JnPiAgICAgICAgICAgIA0KICAgICAgICAg ICAgIG9yYWNsZS1sLWJvdW5jZUBmICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgY2MgDQogICAgICAgICAgICAgcmVlbGlzdHMub3JnICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBTdWJqZWN0IA0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUmU6IGNyZWF0ZV9pbmRleF9jb3N0IHBy b2NlZHVyZSAgICAgDQogICAgICAgICAgICAgMDcvMDcvMjAwOSAxMjowMCAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICBBTSAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICBQbGVhc2Ug cmVzcG9uZCB0byAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K ICAgICAgICAgICAgIGpvbmF0aGFuQGpsY29tcC5kICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgZW1vbi5jby51ayAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgDQoNCg0KDQoNCg0KDQpBbGxvY2F0ZWQgQnl0ZXMgPSAxLDcz NSwwMDAsMDY0ID0gMTMsMjM3IGV4dGVudHMgQCAxMjhLQg0KQWxsb2NhdGVkIEJ5dGVzID0gMSw3 MzYsNDQxLDg1NiA9ICAgIDgyOCBleHRlbnRzIEAgMk1CDQpBbGxvY2F0ZWQgQnl0ZXMgPSAxLDc0 MCw2MzYsMTYwID0gICAgMTY2IGV4dGVudHMgQCAxME1CDQpBbGxvY2F0ZWQgQnl0ZXMgPSAxLDc4 Miw1NzksMjAwID0gICAgIDM0IGV4dGVudHMgQCA1ME1CDQoNCk5vdGljZSB0aGF0IHRoZSBjaGFu Z2UgZnJvbSBvbmUgZmlndXJlIHRvIHRoZSBuZXh0IGlzIGxlc3MgdGhhbg0KdGhlIGxhcmdlciBv ZiB0aGUgdHdvIGV4dGVudCBzaXplcy4gIE5vdGUgYWxzbyB0aGF0IGVhY2ggZmlndXJlIGlzDQph biBleGFjdCBtdWx0aXBsZSBvZiB0aGUgZXh0ZW50IHNpemUuDQoNCk9yYWNsZSBpcyByb3VuZGlu ZyB1cCB0byBhbGxvdyBmb3IgdGhlIHVudXNlZCBwb3J0aW9uIG9mIHRoZQ0KbGFzdCBleHRlbnQu DQoNCg0KUmVnYXJkcw0KDQpKb25hdGhhbiBMZXdpcw0KaHR0cDovL2pvbmF0aGFubGV3aXMud29y ZHByZXNzLmNvbQ0KDQpBdXRob3I6IENvc3QgQmFzZWQgT3JhY2xlOiBGdW5kYW1lbnRhbHMNCmh0 dHA6Ly93d3cuamxjb21wLmRlbW9uLmNvLnVrL2Nib19ib29rL2luZF9ib29rLmh0bWwNCg0KVGhl IENvLW9wZXJhdGl2ZSBPcmFjbGUgVXNlcnMnIEZBUQ0KaHR0cDovL3d3dy5qbGNvbXAuZGVtb24u Y28udWsvZmFxL2luZF9mYXEuaHRtbA0KDQoNCi0tLS0tIE9yaWdpbmFsIE1lc3NhZ2UgLS0tLS0N CkZyb206IDxnZW5lZ3VyZXZpY2hAZGlzY292ZXIuY29tPg0KVG86IDxqb25hdGhhbkBqbGNvbXAu ZGVtb24uY28udWs+DQpDYzogPG9yYWNsZS1sQGZyZWVsaXN0cy5vcmc+OyA8b3JhY2xlLWwtYm91 bmNlQGZyZWVsaXN0cy5vcmc+DQpTZW50OiBNb25kYXksIEp1bHkgMDYsIDIwMDkgMTE6MjYgUE0N ClN1YmplY3Q6IFJlOiBjcmVhdGVfaW5kZXhfY29zdCBwcm9jZWR1cmUNCg0KDQo+IEpvbmF0aGFu Og0KPg0KPiBIZXJlIGlzIG15IG91dHB1dCA6DQo+DQo+IEFsbG9jYXRlZCBCeXRlcyA9IDE3NDA2 MzYxNjANCj4NCj4gQWxsb2NhdGVkIEJ5dGVzID0gMTczNTAwMDA2NA0KPg0KPiBBbGxvY2F0ZWQg Qnl0ZXMgPSAxNzM2NDQxODU2DQo+DQo+IEFsbG9jYXRlZCBCeXRlcyA9IDE3ODI1NzkyMDANCj4N Cj4gVEFCTEVTUEFDRV9OQU1FICAgICAgICAgICAgICAgIEJMT0NLX1NJWkUgSU5JVElBTF9FWFRF TlQgTkVYVF9FWFRFTlQNCj4gTE9HR0lORyAgIEFMTE9DQVRJTyBFWFRFTlRfTUFODQo+IC0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tIC0tLS0t LS0tLS0tDQo+IC0tLS0tLS0tLSAtLS0tLS0tLS0gLS0tLS0tLS0tLQ0KPiBVU0VSUyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAxNjM4NCAgICAgICAgIDEzMTA3MiAgICAgIDEzMTA3Mg0K PiBMT0dHSU5HICAgVU5JRk9STSAgIExPQ0FMDQo+IFBDTV9EXzAzICAgICAgICAgICAgICAgICAg ICAgICAgICAgIDE2Mzg0ICAgICAgICAyMDk3MTUyICAgICAyMDk3MTUyDQo+IExPR0dJTkcgICBV TklGT1JNICAgTE9DQUwNCj4gVU5JQ0FfWF8wMSAgICAgICAgICAgICAgICAgICAgICAgICAgMTYz ODQgICAgICAgMTA0ODU3NjAgICAgMTA0ODU3NjANCj4gTE9HR0lORyAgIFVOSUZPUk0gICBMT0NB TA0KPiBVTklDQV9EXzAxICAgICAgICAgICAgICAgICAgICAgICAgICAxNjM4NCAgICAgICA1MjQy ODgwMCAgICA1MjQyODgwMA0KPiBMT0dHSU5HICAgVU5JRk9STSAgIExPQ0FMDQo+DQo+IHRoYW5r IHlvdQ0KPg0KDQotLQ0KaHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL3dlYnBhZ2Uvb3JhY2xlLWwN Cg0KDQoNCgpQbGVhc2UgY29uc2lkZXIgdGhlIGVudmlyb25tZW50IGJlZm9yZSBwcmludGluZyB0 aGlzIGVtYWlsLgo= -- http://www.freelists.org/webpage/oracle-l