Database table column Index recommendations
| Table | Column(create individual indices on below columns) |
| CPT_CODES | code |
| hc_authorization | certificationnumber, memberid |
| practitioner | nationalprovideridentifier, |
| servicingorg | nationalprovideridentifier |
| pr_index_claimline | claimid, procedurecode |
| provideraffliation | nationalprovideridentifier, taxidentificationnumber |
| businessentity | taxIdentificationNumber, |
| policy | Contracted,policynumber |
| HCPCS_Codes | hcpc |
| contract | contractid |
Previous topic Cache update recommendations Next topic Security