Hi All,

I have a SQL Statement with multiple joins.

Select X Y Z from ......

When I run this statement it runs very fast.

But when I say
Insert into
Select X Y Z from ......
it takes long time.

It doing full scans on couple of tables in the second statement.

What is the issue here ?

Thanks
Sridhar