Re: Foreign key creation on table with huge record count.

Hi,

Ofcourse! You can speed up the execution of creation of FKC (Foreign Key 🔐
constraint) simply by running the *queries that involve joins between the
parent and child tables.*

Foreign key indexes can significantly improve performance for queries that
involve joins between the parent and child tables.

"Join" need to be studied from table to table basis for different databases!

Regards,
Abhishek Singh

*****************************************
*****************************************
*****************************************

Sent using Panasonic - Egula 810 9P
*****************************************
*****************************************

On Tue, 31 Jan, 2023, 01:43 Gambhir Singh, <gambhir(dot)singh05(at)gmail(dot)com>
wrote:

> Hi,
>
> I have a table with a record count of around 100 Million records. while
> creating foreign key on the table took a significant amount time to get
> created.
>
> Is there any way to speed up the execution of creation of foreign key
> constraint ?
>
> do we have parallel hint like option in postgreSQL as there in Oracle.
>
>
> --
> Thanks & Regards
> Gambhir Singh
>
>