Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 19: Which of the following criteria should be taken into account, when choosing index columns? – MySQL Question of the Day

Skip to content

Question 19: Which of the following criteria should be taken into account, when choosing index columns?

15. February 2010
By urs in mysql questions

1 Comment

 
(Find all correct answers)
 

a) is the amount of distinct values of the column relatively high?
b) is the column used in where clauses?
c) is the column used in order by clauses?
d) is the column used in joins?

 
[ Tables and Indexes (15%) - Indexes ]
 

Tags: , ,

Comment Feed

One Response

  1. urs — 15. February 2010 @ 17:34:23 —


    Answers:
     
    a b c d
     
    All of the listed criteria can indicate candidates for indexes.
     

You must be logged in to post a comment.