Ok, since my quries aren't responding, I've been told to drop the table, create the table again, and then import the data. The only index on the table is the primary key. Will it help to add an index for every column to optimize the table? I have queries that pull data from different columns on various pages using the "where" clause. I'm trying to add indexes to a test table to see how it works, but I keep getting an error: ERROR 1121: Column 'gid' is used with UNIQUE or INDEX but is not defined as NOT NULL If I want to add an index to column 'gid', what's the best way? I've read through the manuals and I'm still stuck. Oh, and will this correct my 'query not responding' issue? Thanks a million. Dave Applications Engineer www.gluepoint.com "We make billing easy."
