Select performance against a view

Can someone explain why we are encountering such a difference in response from a select statement against a view.

If we do a simple select:

       select id from big_nasty_view
          where id = 1;

   it returns quickly, but if will include the values

        select id from big_nasty_view
            where id = 1 or id = 2;

    it takes forever, even if we try

          select id from big_nasty_view
               where id in (1,2);

It appears that all of the fields that are referenced in the where clause of the view are indexed(and valid) on their respective tables.

Anyone have any ideas.

Thanks,
Neal Received on Wed Apr 01 1998 - 00:00:00 CST