What is a tuple?

A tuple usually represents an object and information about that object.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #64 - SQL Performance Tuning

EXISTS is efficient when most of the filter criteria is in the main query.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #63 - SQL Performance Tuning

Use Indexed Columns in where clause columns as they return results faster.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #62 - SQL Performance Tuning

IN is efficient when most of the filter criteria is in the sub-query.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #61 - SQL Performance Tuning

Avoid using IN unnecessarily as IN is slowest..

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #60 - SQL Performance Tuning

Try to minimize number of subqueries in your query.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #59 - SQL Performance Tuning

Use actual column names instead of '*' in the queries.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning