Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE+ParadisePapers%0AGO%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.ParadisePapersAddresses%27%29+and+sys.indexes.name+%3D+%27IX_ParadisePapersAddresses_n_country_codes_n_node_id%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_ParadisePapersAddresses_n_country_codes_n_node_id%0AON+ParadisePapersAddresses%28n_country_codes%2C+n_node_id%29%0AEND%0A%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.ParadisePapersEdges%27%29+and+sys.indexes.name+%3D+%27IX_ParadisePapersEdges_node_1_node_2%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_ParadisePapersEdges_node_1_node_2%0AON+ParadisePapersEdges%28node_1%2C+node_2%29%0AEND%0A%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.ParadisePapersEntities%27%29+and+sys.indexes.name+%3D+%27IX_ParadisePapersEntities_n_node_id_n_jurisdiction%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_ParadisePapersEntities_n_node_id_n_jurisdiction%0AON+ParadisePapersEntities%28n_node_id%2C+n_jurisdiction%29%0AEND%0A%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.ParadisePapersIntermediaries%27%29+and+sys.indexes.name+%3D+%27IX_ParadisePapersIntermediaries_n_country_codes_n_node_id%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_ParadisePapersIntermediaries_n_country_codes_n_node_id%0AON+ParadisePapersIntermediaries%28n_country_codes%2C+n_node_id%29%0AEND%0A%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.ParadisePapersOfficers%27%29+and+sys.indexes.name+%3D+%27IX_ParadisePapersOfficers_n_country_codes_n_node_id%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_ParadisePapersOfficers_n_country_codes_n_node_id%0AON+ParadisePapersOfficers%28n_country_codes%2C+n_node_id%29%0AEND%0A%0A%0A%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.ParadisePapersOthers%27%29+and+sys.indexes.name+%3D+%27IX_ParadisePapersOthers_n_country_codes_n_node_id%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_ParadisePapersOthers_n_country_codes_n_node_id%0AON+ParadisePapersOthers%28n_country_codes%2C+n_node_id%29%0AEND%0A%0Aif+not+exists%28select+1%0A++++++++++from+sys.indexes%0A++++++++++where+sys.indexes.object_id+%3D+object_id%28%27dbo.CountriesInfo%27%29+and+sys.indexes.name+%3D+%27IX_PCountriesInfo_alpha3%27%29%0ABEGIN%0ACREATE+NONCLUSTERED+INDEX+IX_PCountriesInfo_alpha3%0AON+CountriesInfo%28%5Balpha-3%5D%29%0AEND
Add Comment
Please, Sign In to add comment
