Re: Optimisation of a sql query

On 19 Jul 2006 13:47:00 -0700, "Abhijat" <ursabhijat_at_gmail.com> wrote:

>A quick note to Sybrand and David: I guess I could not make myself very
>clear in my last mail. I am not working on Oracle tables. I am working
>in SAS and working with SAS datasets. Hence, the version still remains
>to be SAS 9.1. Please help with regards to this.

SAS is not a database, and needs a database. If the database you are using is not Oracle, why are you posting this here? The advice you are getting will be inevitably geared at Oracle, and the possibilities and impossibilities of the optimizer Oracle provides. I don't think anyone here has any SAS knowledge.

Also, if the affected table has been properly indexed, and the HAVING clause is not being misused to get a non-performant sql-statement, the size of the table doesn't matter at all.

In summary: we still don't know anything, and chances are you are using Oracle and don't know anything about it. In that case it will be very difficult to help you out, as we won't go on asking for information forever, and we are not looking over your shoulder.

--
Sybrand Bakker, Senior Oracle DBA