...

View Full Version : How to add index in database?



funhunter
02-15-2006, 10:38 AM
Hi , I want to add a new field 'sex' to an exiting table which has 12 fields already, then I add an index(username,sex) to use for query which find user's gender. (username is the primary key ) .Is it better or not compared to creating a new table which has only 2 fields username and sex ?

Jak-S
02-15-2006, 10:09 PM
Yeah, sounds like you just need to add an extra field to the existing table, theres nothing wrong with having more than 12 fields.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum