Re: What index do I need for this query ?

From: <sybrandb_at_hccnet.nl>
Date: Wed, 25 Mar 2009 06:40:10 +0100
Message-ID: <0lgjs4h2t9nrdk3vrid5di9ekr907qc0vh_at_4ax.com>

On Tue, 24 Mar 2009 18:27:15 -0700 (PDT), krislioe_at_gmail.com wrote:

>Hi Mr,
>
>Below is the Plan : I have two index now
>
>CREATE INDEX INVOICE_H_IDX2 ON INVOICE_H (INV_NO)
>
>CREATE INDEX INVOICE_H_IDX3 ON INVOICE_H(TAXDATE)
>
>Thank you,
>xtanto

You really NEVER do anything yourself, don't you? Above that you are also extreemly rude!!! I spent several hours of my *Sun*day to resolve your performance problems (In all those years asking RTFM questions you still didn't learn anything, so the application and the database are a disaster), and you never responded to thank me.
Why is it that you are so extreemly lazy and extreemly rude? Underpaid? Didn't get your ass kicked often enough by your mother when you grew up? Or did you just never grew up? Or are you one of those thousands of incompetent Asian DBAs parasiting Usenet and OTN?

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Wed Mar 25 2009 - 00:40:10 CDT