X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 727F84760CC for ; Tue, 8 Apr 2003 22:35:31 -0400 (EDT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by postgresql.org (Postfix) with ESMTP id 8671B475E77 for ; Tue, 8 Apr 2003 22:35:27 -0400 (EDT) Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6p2/8.11.6) id h392ZVK50833 for pgsql-performance@postgresql.org; Wed, 9 Apr 2003 10:35:31 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6p2/8.9.3) with SMTP id h392ZCx50663; Wed, 9 Apr 2003 10:35:12 +0800 (WST) Message-ID: <077201c2fe40$ab420d70$6500a8c0@fhp.internal> From: "Christopher Kings-Lynne" To: , , References: Subject: Re: [SQL] Yet Another (Simple) Case of Index not used Date: Wed, 9 Apr 2003 10:35:22 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: base64 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Spam-Status: No, hits=-11.1 required=5.0 tests=BASE64_ENC_TEXT,BAYES_20,QUOTED_EMAIL_TEXT,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/81 X-Sequence-Number: 1587 SGkgRGVuaXMsDQoNCj4gVGhlIGtpbmQgb2YgcmVxdWVzdHMgdGhhdCBJIGFt IHJlYWxseSBpbnRlcmVzdGVkIGluIGFyZToNCj4gc2VsZWN0IGNvdW50KCop IGZyb20gdGFibGUgd2hlcmUgdGFibGUuY29sdW1uIGxpa2UgJ3BhdHRlcm4l Jw0KPiBUaGVzZSBzZWVtcyB0byBnbyBtdWNoIG1hc3RlciBvbiBteXNxbCAo d2hpY2ggSSBndWVzcyBpdCBub3QgYSBNVkNDIGRhdGFiYXNlPyBvciB3YXNu J3QgDQo+IHRoZSBJbm5vYmFzZSBzdXBwb3NlZCB0byBtYWtlIGl0IHNvPyks IHRoYW4gb24gcG9zdGdyZXNxbC4NCg0KQSBmZXcgdGhpbmdzLg0KDQoqIE1W Q0MgaW4gUG9zdGdyZVNRTCBhbGxvd3MgdXMgdG8gYmUgd2F5IGZhc3RlciB0 aGFuIE15U1FMIHdoZW4geW91IGhhdmUgaGVhcHMgb2YgY29uY3VycmVudCBy ZWFkZXJzIGFuZCB3cml0ZXJzLiAgVGhlIHRyYWRlb2ZmIGlzIHRoYXQgY291 bnQoKikgaXMgc2xvdyBzaW5jZSBQb3N0Z3JlU1FMIG5lZWRzIHRvIGNoZWNr IHRoYXQgZWFjaCB0dXBsZSBpcyBhY3R1YWxseSB2aXNpYmxlIHRvIHlvdXIg cXVlcnkgKGVnLiB5b3Ugc3RhcnQgYSB0cmFuc2FjdGlvbiwgc29tb25lIGVs c2UgaW5zZXJ0cyBhIHJvdywgeW91IGRvIGEgY291bnQoKikgLSBzaG91bGQg dGhlIHJlc3VsdCBpbmNsdWRlIHRoYXQgbmV3IHJvdyBvciBub3Q/ICBBbnN3 ZXI6IG5vLikNCg0KKiBKdXN0IGF2b2lkIGRvaW5nIGNvdW50KCopIG92ZXIg dGhlIGVudGlyZSB0YWJsZSB3aXRoIG5vIHdoZXJlIGNsYXVzZSEhISBJdCdz IGFzIGVhc3kgYXMgdGhhdA0KDQoqIFRoZSBMSUtFICdwYXR0ZXJuJScgaXMg aW5kZXhhYmxlIGluIFBvc3RncmVzcWwuICBZb3Ugd2lsbCBuZWVkIHRvIGNy ZWF0ZSBhIG5vcm1hbCBidHJlZSBpbmRleCBvdmVyIHRhYmxlLmNvbHVtbi4g IFNvIGxvbmcgYXMgdGhlIGluZGV4IGlzIHJldHVybmluZyBhIHNtYWxsIHBv cnRpb24gb2YgdGhlIHRhYmxlIChlZy4gc2F5IG9ubHkgNS0xMCUgb2YgdGhl IGZpZWxkcyBiZWdpbiB3aXRoIHBhdHRlcm4pLCB0aGVuIHRoZSBpbmRleCB3 aWxsIGJlIHVzZWQgYW5kIGl0IHdpbGwgYmUgZmFzdC4NCg0KKiBJZiB5b3Ug d2FudCByZWFsbHkgZmFzdCBmdWxsIHRleHQgaW5kZXhpbmcsIGNoZWNrIG91 dCBjb250cmliL3RzZWFyY2ggLSBpdCdzIHJlYWxseSwgcmVhbGx5LCByZWFs bHkgZmFzdC4NCg0KQ2hyaXMNCg==