On 11/16/2010 1:44 AM, Tanmoy Ghoshal wrote:

> Hi Set,
>
> Thank you for reply.
>
> I have more than 1500 constant values. Here IN not accept more than 1500, then
> what is the best way to write SQL to get data in less time.
>
> I need to write SQL which should not take much time to execute.
>
> As a beginner, If possible Please help me

You said you have more than 1500 constant values. Are these values
actually constant - they do not change between program runs?

--
Daniel