Thats a good idea, at the database level.
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<lennart_at_kommunicera.umea.se> wrote in message
news:1138809481.959167.5170_at_g44g2000cwa.googlegroups.com...
>
> Tony Rogerson wrote:
>> Good point, but I'd rather have the control, consider a trading table
>> that
>> you don't delete from as one example, there are dozens of others.
>>
>
> Another point worth mentioning is that one sometimes want to create
> indexes with physical details like PCTFREE, CLUSTER etc. Atleast DB2
> complains that it will not create an index for you, if there already is
> an index on the same columns. Perhaps a DB or DBMS cfg parameter that
> determined whether index are auto created or not would be nice.
>
>
> /Lennart
>
> [...]
>
Received on Wed Feb 01 2006 - 15:04:18 CST
