add_clean_index( string $table, string $index )

Adds an index to a specified table.

Parameters

$table

(Required) Database table name.

$index

(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;
}

Expand Source Code View on GitHub

Related

Uses

Uses
Uses Description
wp-includes/wp-db.php: wpdb::query()

Perform a MySQL database query, using current database connection.
wp-admin/includes/upgrade.php: drop_index()

Drops a specified index from a table.

Changelog

Changelog
Version Description
WP-1.0.1 Introduced.