Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jan 2006
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to add index in database?

    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 ?

  • #2
    Regular Coder
    Join Date
    Mar 2005
    Location
    Brighton, UK
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yeah, sounds like you just need to add an extra field to the existing table, theres nothing wrong with having more than 12 fields.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •