Hi, I have the following Table : CREATE TABLE users ( uid INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(100) UNIQUE NOT NULL DEFAULT '', email VARCHAR(255) UNIQUE NOT NULL }
I wanted to know if I create an INDEX for the column "email" what isg going to be the extra space the index will occupy ? By extra space I mean the extra amount of disk space required by the index ? I tried to search for any docs on this but couldnt. This table is going to have 1 Million records and I need to save space here. Adding an index makes the lookup very fast. Regards, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
