Warning: Use of undefined constant jq_syntax_htmlentities - assumed 'jq_syntax_htmlentities' (this will throw an Error in a future version of PHP) in /usr/home/sqlabs/public_html/sqlabs/blog/wp-content/plugins/jquery-syntax/jquery-syntax.php on line 37

Warning: Use of undefined constant jq_syntax_htmlentities - assumed 'jq_syntax_htmlentities' (this will throw an Error in a future version of PHP) in /usr/home/sqlabs/public_html/sqlabs/blog/wp-content/plugins/jquery-syntax/jquery-syntax.php on line 38

Indexing a database seems more art than science and proper indexes can have a tremendous speed up for your queries. This really nice talk can help to make better decision and more important can help to make better index design: