I have placed indexes on several columns of a table. My question is in order to use the indexes properly do I have to make mention of the indexes in the query or select statement at all or can I just run something like this--
select * from table_name where column_username='$username' and column_password='$password';
I have a table with eight columns and I have indexes on the columns "username" and "password". Do I need to do anything else in the select statement?
Thanks,
Owen The Samoan