1 Reply Latest reply on Jun 24, 2016 12:59 PM by Tom W

    Why the query with parameter is slow?

    Gagan Thapar

      I have a query:

       

      select * from x, y

      where x.a = y.a

      and x.c = '1234ABC'

       

      this query runs very quickly, instead if I use:

       

      select * from x,y

      where x.a = y.a

      and x.c = <Parameter1>

       

      and put value 1234ABC in parameter, the query is slow. Can anyone please help why?