Posted by Erland Sommarskog on 04/16/07 22:18

Igor (jerosimic@gmail.com) writes:
> I currently have two tables:
> 1: users
> id_user
> username
>
> 2: baned_users
> id_user
>
> i tought i could use something like this
> 1: users
> id_user
> username
> is_baned
>
> So would it be better to use two tables like in first example or one
> table like in second example? Offcourse, not many users would be baned
> (i hope). I currently have 59 joins with baned_users table in my
> stored procedures, two of those are executed on every access to the
> website (2xtop 20 users), what way should i use?

The second design is the more natural design in my opinion. There could
be situations where the first design is better for performance, if you
often need to review the list of banned users, but that does not seem to
be a critical task in this case.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]