Simon Riggs <[EMAIL PROTECTED]> writes: > I agree, hence why this should be a user option. The usage of this is > restricted to particular classes of database usage: data warehousing or > very large database applications. This isn't intended for use in OLTP or > web-site databases.
Well a lot of users also just don't use online backups. For these users there's no downside to CREATE INDEX/REINDEX/CREATE TABLE AS not logging. The logging is not needed for a regular recovery, only for restoring from and a backup older than the table/index creation. -- greg ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]