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]
