MySQL Indexing general question

[Nino Skilj]

I'm a bit confused about indexing using MySQL. I have something like
this:

Table:
PEOPLE

Values:
user_id
first_name
last_name
email

I put an index on user_id to speed up my search for:
select first_name, last_name, email from PEOPLE where user_id=xxx;

The question I have is:
Once I set up the index, does it only hold true for the data that was
currently in the table at the time the index was created? In other
words, if I add 100 more users tomorrow, will I have to rebuild the
index on user_id, or does MySQL automatically adjust for that?

Nino

[BDR]

Yes, Mysql will automatically compensate for additions, entry
modifications and deletions using this type of index. You shouldn't
have to do anything.

Nino Skilj wrote:

I'm a bit confused about indexing using MySQL. I have something like
this:

Table:
PEOPLE

Values:
user_id
first_name
last_name
email

I put an index on user_id to speed up my search for:
select first_name, last_name, email from PEOPLE where user_id=xxx;

The question I have is:
Once I set up the index, does it only hold true for the data that was
currently in the table at the time the index was created? In other
words, if I add 100 more users tomorrow, will I have to rebuild the
index on user_id, or does MySQL automatically adjust for that?

Nino

[BDR]

Yes, Mysql will automatically compensate for additions, entry
modifications and deletions using this type of index. You shouldn't
have to do anything.

Nino Skilj wrote:

I'm a bit confused about indexing using MySQL. I have something like
this:

Table:
PEOPLE

Values:
user_id
first_name
last_name
email

I put an index on user_id to speed up my search for:
select first_name, last_name, email from PEOPLE where user_id=xxx;

The question I have is:
Once I set up the index, does it only hold true for the data that was
currently in the table at the time the index was created? In other
words, if I add 100 more users tomorrow, will I have to rebuild the
index on user_id, or does MySQL automatically adjust for that?

Nino

[Nino Skilj]

Thank you so much!

Nino

BDR <jo*@noemail.co m> wrote in message news:<3F******* *******@noemail .com>...

Yes, Mysql will automatically compensate for additions, entry
modifications and deletions using this type of index. You shouldn't
have to do anything.

Nino Skilj wrote:

I'm a bit confused about indexing using MySQL. I have something like
this:

Table:
PEOPLE

Values:
user_id
first_name
last_name
email

I put an index on user_id to speed up my search for:
select first_name, last_name, email from PEOPLE where user_id=xxx;

The question I have is:
Once I set up the index, does it only hold true for the data that was
currently in the table at the time the index was created? In other
words, if I add 100 more users tomorrow, will I have to rebuild the
index on user_id, or does MySQL automatically adjust for that?

Nino

[Nino Skilj]

Thank you so much!

Nino

BDR <jo*@noemail.co m> wrote in message news:<3F******* *******@noemail .com>...

Yes, Mysql will automatically compensate for additions, entry
modifications and deletions using this type of index. You shouldn't
have to do anything.

Nino Skilj wrote:

I'm a bit confused about indexing using MySQL. I have something like
this:

Table:
PEOPLE

Values:
user_id
first_name
last_name
email

I put an index on user_id to speed up my search for:
select first_name, last_name, email from PEOPLE where user_id=xxx;

The question I have is:
Once I set up the index, does it only hold true for the data that was
currently in the table at the time the index was created? In other
words, if I add 100 more users tomorrow, will I have to rebuild the
index on user_id, or does MySQL automatically adjust for that?

Nino