Indexing columns of bit type

Clearly, an index build on only one column of the bit type is useless because the selectivity is poor (50% of a table in average). However, when a table has several columns of the bit type, the composite index may be efficient.

For the test example, we'll create a table and fill it with random data.

Dynamic filtering with SQL

The one of the most frequent asked question in database development is "How to filter the data returned by a query according to some user selected criteria?". To complete the solution with dynamic ordering see my other blog post.

For every method template I will add icons indicating corresponding advantages and drawbacks.

OffSite Builder CMS

Need to manage your website's contents?

  • Do you need to manage your website's contents, but you wouldn't like to install and support some contents management system (CMS)?
  • Do you want to develop your website's design separately from its contents?
  • Do you prefer to use open standards and technologies like XML and XSLT?

OffSite Builder will help you.

Pages

Subscribe to Mechanics of software RSS