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

[Abhishek Singh <abhi.singh.solanki@xxxxxxxxx>]

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.singh05@xxxxxxxxx> 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