DA Morgan wrote:
> Oradba_Linux wrote:
>
>> with update global indexes.
>> We did this on 2 partitions of different tables today and timings were
>> very different.One was 10 minutes and other was 100 minutes. Number of
>> rows are similar but the table that took longer had one more index.
>> But that index was on a nullable column and it was very small.
>> I know i am little ambiguous here but just looking for some guesses.
>>
>> Thanks
>
>
> TK_PROF.
I have already truncated the partitions. So tkprof can be used only next
time.
Received on Thu May 12 2005 - 19:50:06 CDT
