Posted by rcamarda on 10/09/06 10:19

Thanks Damien,
You are correct. I am using Cognos' Data Manager to build my data
warehouse. In on database, I truncate and reload all the data via it's
SQL API, so I loads pretty quick. It maintains the indexes, however I
indexes I build outside the tool. Since I truncate the tables, I dont
want indexes updated during the load, I will build them after. Hence,
the need to drop all indexes of my table before I load the data.
TYVM!
rOB
>
> I assume you're doing this for some kind of maintenance procedure in
> your database, where you've already scripted off all of the indexes.
>
> Damien

• Next in forum: Re: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
• Prev in forum: Re: Drop all indexes in a table, how to drop all for user tables in database
• Thread view: Re: Drop all indexes in a table, how to drop all for user tables in database

[Reply to this message]