Received: from ganesh.paneris.org (IDENT:root@paneris.org [194.128.98.74]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA37448 for ; Wed, 27 Oct 1999 06:00:21 -0400 (EDT) (envelope-from tim@hoop.co.uk) Received: from noonoo (flav1.dircon.co.uk [194.112.47.31]) by ganesh.paneris.org (8.8.7/8.8.7) with SMTP id KAA07814 for ; Wed, 27 Oct 1999 10:58:35 +0100 Message-ID: <00b501bf2062$910e71b0$0501a8c0@noonoo> From: "Tim Joyce" To: References: Subject: QUERY PLAN: Date: Wed, 27 Oct 1999 11:03:45 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 can someone point me at documentation so that i can unserstand the results of an EXPLAIN, eg: Index Scan using words_id_idx on books_idx (cost=441.19 rows=7644 width=8) explain select * from books_idx where wrd_id=1; I am paticularly interested in what the rows= figure means. TIA timj