Re: Simple Oracle Query Taking Too Long

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 6 Sep 2006 12:38:34 -0700
Message-ID: <1157571514.649256.310500@m79g2000cwm.googlegroups.com>

I don't want to insult you, but ...
The number of rows in the table, and the indexing really would not matter with the query you supplied. What you are describing sounds a lot like a query going against a view, instead of a table, and supposing that the view definition has a group by, sorting order, join of multiple tables, or any other hidden complexity, then any of those would more then justify the delay (anything more then a fraction of a second for retrieving a row from a table).

What does the following show ...
Select owner,object_type from all_objects where object_name='ABC';

Can you confirm this. Received on Wed Sep 06 2006 - 14:38:34 CDT