W3cubDocs

/WordPress

add_clean_index( string $table, string $index )

Adds an index to a specified table.

Parameters

$table: (string) (Required) Database table name.
$index: (string) (Required) Database table index column.

Return

(true) True, when done with execution.

Source

File: wp-admin/includes/upgrade.php

function add_clean_index( $table, $index ) {
	global $wpdb;

	drop_index( $table, $index );
	$wpdb->query( "ALTER TABLE `$table` ADD INDEX ( `$index` )" );

	return true;
}

Uses

Uses	Description
wp-admin/includes/upgrade.php: drop_index()	Drops a specified index from a table.
wp-includes/wp-db.php: wpdb::query()	Performs a MySQL database query, using current database connection.

Changelog

Version	Description
1.0.1	Introduced.

© 2003–2019 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/add_clean_index