Re: Index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


What will happen if index is not managed in this case? 

On Sun, 10 Mar 2024, 17:20 Holger Jakobs, <holger@xxxxxxxxxx> wrote:
Am 10.03.24 um 12:19 schrieb Rajesh Kumar:
> Hi ,
> I have a table where size is increasing daily. In that table only
> inserts and deletes happens. This table is referencing 15 other
> tables. We have given delete cascade, so if a row is deleted in parent
> table,  the matching records will also be deleted in those child tables.
> It is taking lot of time to delete. So, I am planning to create index
> on those child tables.
> My question is, apart from inserts, I am only going to delete records
> from those tables. How index improves performance for deleting
> records? How index is affected or how to do index management in this case?


Since every single row which is going to be deleted in the child tables
has to be found, an index can be of great help here.

Actually, in most (not all!) cases an index on foreign key columns makes



Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux