...help. I want to create a index to help the following statement run faster, can anyone suggest which would be the best index to create
select * from profile, album, movie, book, contact
where profile.album = album.albumid
and profile.movie = movie.movieid
and profile.book = book.bookid...