If I select a subset of tableA using:

select * from tableA where ...

subsequent queries with the resulting table are 3-4 times faster than if the iniial subset is done using:

select tableA.field1, tableA.field2 ...

where the only difference is specifying specific fields vs. the *. I've also tried to place a nofilter on the fast query trying slow it down but it doesn't matter.

Thanks,
Rock Jensen