Month: February 2013

  • why i choose one big table for the same sets of data

    – Seek time with proper index, should be exactly the same, no matter how wide”table is. Apart from performance issues, this will simplify design and relations with other tables (foreign keys etc). – code little Assuming that table B is exact copy of table A, and that all necessary indexes are created, self-join of table […]