def METHOD_NAME(self):
    indexes_sql = (self.matview_dir / "componentized" / f"{TABLE_NAME}__indexes.sql").read_text()
    with connection.cursor() as cursor:
        cursor.execute(indexes_sql)
        rows = cursor.fetchall()
    create_temp_indexes = []
    rename_indexes_old = []
    rename_indexes_temp = []
    for row in rows:
        index_name = row[0]
        index_name_temp = index_name + "_temp"
        index_name_old = index_name + "_old"
        # Ensure that the index hasn't already been created by a constraint
        if index_name not in self.constraint_names:
            create_temp_index_sql = row[1].replace(index_name, index_name_temp)
            create_temp_index_sql = create_temp_index_sql.replace(
                f"{TABLE_SCHEMA_NAME}.{TABLE_NAME}", f"{TABLE_SCHEMA_NAME}.{TABLE_NAME}_temp"
            )
            create_temp_indexes.append(create_temp_index_sql)
            rename_indexes_old.append(f"ALTER INDEX IF EXISTS {index_name} RENAME TO {index_name_old};")
            rename_indexes_temp.append(f"ALTER INDEX IF EXISTS {index_name_temp} RENAME TO {index_name};")
    return create_temp_indexes, rename_indexes_old + rename_indexes_temp