ColdFusion Question: If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the LEFT JOIN query? ColdFusion Interview QuestionAnswer: movie_id Previous QuestionNext QuestionHow would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?How would you write a LEFT JOIN statement to return a result set of movie.title’s and director.name’s?
