We have a select with subselects that are causing a lot of data to be written to the logical logs. When I take out the subselects, the logging activity stops. Does the subselect cause data to be written to logical logs, and how can this be prevented---for example, the no log option when using temp tables?


Thanks

Mark

put your select here.

But in generally, you can avoid writing to the logical logs by:
using temp tables with no log option
using raw tables
turning off database logging

ps:select is read only operation...i don't think it is the cause of using logical logs.