CODEWITHSUNDEEP
sqlmysqlindexing
never_had_a_name
never_had_a_name

Reputation: 93206

How and when to update a MySQL index?

I'm using this SQL query to create an index:

    $query = "CREATE INDEX id_index2
            ON countries(geoname_id, name)";

How do I update the index when new entries are added?

Should I run a PHP script with the update query in CRON and run it every night?

Is this best practice for automated index updating?

Upvotes: 4

Views: 6521

Answers (2)

Wael Dalloul
Wael Dalloul

Reputation: 23024

It will be automatically updated after adding rows, No need to run any update statements.

Upvotes: 2

Amy B
Amy B

Reputation: 17977

Indexes are updated by MySQL automatically as you insert/update rows. (This may be a performance hitter for huge websites, but you probably aren't running a huge one :).) You don't need to do anything after the initial creation.

Upvotes: 9

Related Questions