From: Dan Nelson
Date: July 27 2009 4:15am
Subject: Re: When does indexing happen?
List-Archive: http://lists.mysql.com/mysql/218291
Message-Id: <20090727041506.GW63413@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 26), buford@stripped said:
> Using version 5.0.6x on RH. The question I have is about the updating of
> indexes.
> 
> Say I have a table with a primary key and one or more indexes. I run an
> INSERT statement by way of a call to mysql_real_query() in the C api. If
> that function call returns zero, i.e., indicating success, does that mean
> that everything is guaranteed to be completed? In particular that all the
> table indexes have been updated, so that an immediately-subsequent SELECT
> statement with an appropriate WHERE clause seeking for the same row will
> find it using the index?

Yes.

-- 
	Dan Nelson
	dnelson@stripped