Re: tuning query with concat string.
- From: "LiShan Cheng" <exriscer@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Tue, 21 Mar 2006 16:53:48 +0100
Hi
You dont have problem with that query if your column is indexed, ws_id has
high cardinality (S'||userenv('SESSIONID') as well)
You will have problem (unless you use FBI) if you concat in the column such
as
S||ws_id
On 3/21/06, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
>
> I think my question was littble confused.
>
> Okay, following is the query that I wanted to write,
>
> select max(start_time) from fm_audit_form where ws_id =
> 'S'||userenv('SESSIONID')
>
> Is there any way that I can rewrite this query?
>
> Long time ago, I have read that we can rewrite queries that has concat
> in the where clause values.
>
>
>
> On 3/21/06, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> > SELECT ...... FROM where COLUMN = 'SVALUE2';
> >
> > :-)
> >
> > Quoting The Human Fly <sjaffarhussain@xxxxxxxxx>:
> >
> > > How can I rewrite the query which uses concatination in the where
> > > clause? For an example,
> > >
> > > SELECT ...... FROM where COLUMN = 'S'||'VALUE2';
> > >
> > --
> > regards
> >
> > Wolfgang Breitling
> > Oracle 7,8,8i,9i OCP DBA
> > Centrex Consulting Corporation
> > www.centrexcc.com
> >
> >
>
>
> --
> Best Regards,
> Syed Jaffar Hussain
> 8i,9i & 10g, OCP DBA
> Banque Saudi Fransi,
> Saudi Arabia
> http://jaffardba.blogspot.com/
>
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
