Hi, Bob, Generally, you can have as many as you need.
No, you don't have to delete your ID index. In fact, you have to have a primary index in order to enter any data at all. All additional indexes (indices?) do is to make ordering faster when you order on the index parameters. For a name and address database, with only a few records (less than thousands) you are unlikely to experience any performance improvements by creating additional indexes. Unless you are processing many records at a time many times a day, don't bother making additional indexes. Just use ORDER BY clauses in your sql statements and be done with it. John On Fri, Sep 18, 2009 at 1:59 PM, Bob Williams <[email protected]>wrote: > Hi, > > How many indexes can a database have? I have created a simple, flatfile, > name > and address type database. Each entry has an auto-incremented ID number, > which > was set as the primary index in the design stage. Now that I've got some > records in there, I'd like to index it on Lastname then Firstname in A-Z > ascending order. Do I have to delete the ID index, which is called > SYS_IDX_46, > first? Will this activate my new 'Names' index automagically? > > Thanks, > > Bob > -- > Registered Linux User #463880 FSFE Member #1300 > GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E > openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 > Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
