-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 yoky wrote: > I create a table with 200 columns,
If you have that many columns but want queries with only some of them, then it is a good indication that your schema is not normalized. See the wikipedia entry for some guidance: http://en.wikipedia.org/wiki/Database_normalization Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkZB2oACgkQmOOfHg372QTozgCfcas7IG8BKsHYiwYp3pIqnws3 6cYAoMMgemIpLnUZ1AKO9d5tOSfydu3K =G41a -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users