How big is that table? Can you post your SQL? Do you have index for columns in the WHERE clause?
>Hi,
>I have a program, that allows the user to look up data on various tables in a database. While all queries work, when a query is executed on one specific table, the system just hangs. What could be th problem? Is it likely that this table is corrupted and needs to be reindexed?
>
>Thank you.
>
>Ria
- Jayesh