sql optimaze query

optimaze query
create index and use index to query:
step1: create index for table.
step2: query parma has the index columns.

eg: search a user with userid.
if user is a member of group.
then set the groupid as index of table user.
because groupid's number is smaller then userid.
so search a user with(groupid,userid).