Re: QQQ

From: <fitzjarrell_at_cox.net>
Date: 14 Jul 2005 13:58:19 -0700
Message-ID: <1121374699.497076.277020@g49g2000cwa.googlegroups.com>

soalvajavab1_at_yahoo.com wrote:
> Is calculations on an indexed column make index unused? is there any
> solution?
>
> Does UNION better than OR? what about NOT EXISTS and HAVING
>
> Is LIKE make index unused too? what we can do for that?
>
> What's the pros and cons of using subqueries instead of JOIN?
>
> Can we disable an index by concatenating a null or 0 to the column
> name?
>
> if we need more that 20% of the rows in the table is FTS is better?
>
> what exactly bind variable help in performance? is it really bifg deal
> or not?

Do your own homework. Do NOT expect US to do it for you.

tahiti.oracle.com

Start reading.

David Fitzjarrell Received on Thu Jul 14 2005 - 15:58:19 CDT