New topic: Is an index needed on two column table
<http://forums.realsoftware.com/viewtopic.php?t=31441> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message dplaut Post subject: Is an index needed on two column tablePosted: Sun Dec 06, 2009 3:58 pm Joined: Mon Jun 23, 2008 3:04 pm Posts: 61 If I have a table that I am using to populate a combo box, strSQL = "CREATE TABLE lkPeople" _ + "(" _ + "PeoplelD INTEGER PRIMARY KEY AUTOINCREMENT," _ + "PeopleName VarChar NULL" _ + ")" I'm using the name field to be displayed in the combo box sorted alphabetically by name. Is there any point to indexing the PeopleName field? Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
