Re: Row Count

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1998/02/01
Message-ID: <01bd2ef2$8fea9240$294b989e_at_WORKSTATION>#1/1

Taking a sidewise approach to this

How about intercepting the query, using explain plan to load a plan table, then reading the cost from row 0 of the plan. (Relevant only to Cost Based Queries). Row 1 of the plan is nominally going to have a cardinality which is the number of rows the optimiser thinks it will get, but this can be very misleading (even when it works) on queries with GROUP BYs. Received on Sun Feb 01 1998 - 00:00:00 CET

This message: [ Message body ]
Next message: ajitsingh_at_hotmail.com: "Re: Row Count"
Previous message: Bill Bollhorst: "Row Count"
In reply to: Bill Bollhorst: "Row Count"
Next in thread: ajitsingh_at_hotmail.com: "Re: Row Count"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message