Re: A lot of updates

Hi David,

    By tuning it .....

    Sorry, I couldn't resist that. You really haven't provided enough information for anything other than a very general response -- which may prove invalid given specific requirements on your part.

    Factors that influence performance when doing updates tend to be related to the cost of altering indexes and the cost of handling rows that grow in size and must be split across more than one data base block.

    Try not to update indexed columns in your table. In particular, if you are updating a column -- other than the first -- in a compound index you should consider removing it from the index. This sounds pretty radical, but since an index is used only if the first column in the index is named in a where clause and since the first column alone should eliminate most of the table from consideration it merits investigation.

    As far as data goes, the best quick fix is to have a high PCTFREE value for the table so that each data block will have room for adequate expansion of its rows.

    If you can provide more specific information someone will be able to come with specific solutions.

Regards
Jerry Gitomer

David Novo wrote in message <7qh30v$lbu$1_at_talia.mad.ttd.net>...
>If I have a database with a lot of updates, how I can obtain
more
>performance ¿?
>
>Thanks
>David
>
>
Received on Wed Sep 01 1999 - 09:30:23 CDT