ColdFusion Question:
Download Questions PDF

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?

Answer:

movie_id

Download ColdFusion Interview Questions And Answers PDF

Previous QuestionNext Question
How 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?