Re: Problem with Accessing Oracle Database w/ MS Query

hello,
  More information would be helpful, still, some comments:

If the query you are running only contains the view then you should not have any problems as all the work is done on the Oracle server.

However, if you are doing a join to the view then you could have fun. If you use MS Access, you will find that it cannot 'see' any indexes on the tables used in the view! Guess how i found out? You may need to specify 'passthru queries' etc.
OR
You will have to create indexes in the MS Database engine at the client side. See the help in MS Access. I think that MS Query will use the client side indexes if they are available. Hopefully an MS Query expert will confirm (or not) about this?

As you will have guessed this rapidly gets out of my field of expertise!

I am going to learn more about MS Query from your question.

graham (aka grumpy)

"Tom Haley" <comett_at_creighton.edu> wrote...

| Greetings,
|
| I'm not sure if anyone else has had this problem or not, but I am in need
| of some assistance. I am trying to use MS -Query to connect to an oracle
| database and execute a select query. I don't have any trouble connecting
| to the database or attaching to the oracle tables. The problem occurs when
| I try to run a query against a "view". When I run the query it either
| takes a very long time to return, or it doesn't come back at all.
|
| If anyone has found asolution to the problem or a work around, please let
| me know.
|
| Thanks,
|
| Tom Haley
| Information Systems Manager
| Creighton University
| comett_at_creighton.edu

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost. Received on Sat May 17 1997 - 00:00:00 CDT