How to make an index in a DB

[phpmotion]

There is a recommendation that if you index your DB it can be searched faster but how do you do that effectively?

[geek]

You can go to phpmyAdmin and do that. Go to the DB you want then the table and row and select and make it and index.

[wilber]

You also have to adjust your coding to query the indexed part.

[clipshare]

Go to PhPMyAdmin, go to the DB and then the table you want. Click on structure and then the line you want. One of the icons there will give the option to index.

[wilber]

You should also do a repair and optimize after just to make sure everything is working on optimal fashion.

[geek]

The repair and optimize should be done regular and not just as part of an index.

[wilber]

Yes I agree with that. I know some people have a cron to do this automatically but I don't like doing it like that.