table optimization

2001-01-15 Thread David Young
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

Re: query not responding

2001-01-15 Thread David Young
ke billing easy." - Original Message - From: Scott Baker <[EMAIL PROTECTED]> To: David Young <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 15, 2001 9:01 AM Subject: Re: query not responding > Sounds to me like your indexes got corrupted. You can try fixin

query not responding

2001-01-13 Thread David Young
Ok, here's the scoop. After 3 days of research, noone has been able to give me an answer ...hopefully someone here can..yay! Anyway, I've got several tables all with 350+ records. The db itself has about 15 tables. When I run this query: "select field1 from table1;" it just sits there. When