oracle view

[EternalOptimist]

i have a link to an oracle view. I want to query it and link it to some indexed tables, I am using decode quite a bit.

the view returns 3 million rows, my result is 2.5 k rows.


the problem is that my 2.5k rows takes 40 minutes to produce. The oracle dba will not supply the view sql, he will not let me build any temp tables or functions.

is there any other way I can speed this up ?

[DimPrawn]

i have a link to an oracle view. I want to query it and link it to some indexed tables, I am using decode quite a bit.

the view returns 3 million rows, my result is 2.5 k rows.


the problem is that my 2.5k rows takes 40 minutes to produce. The oracle dba will not supply the view sql, he will not let me build any temp tables or functions.

is there any other way I can speed this up ?

Yes, put it into a decent modern database like SQL Server 2008.

[voodooflux]

Yes, put it into a decent modern database like SQL Server 2008.

Duck everybody - incoming!

[Spacecadet]

how long does a select on the view without linking to other tables take to run?

[expat]

i have a link to an oracle view. I want to query it and link it to some indexed tables, I am using decode quite a bit.

the view returns 3 million rows, my result is 2.5 k rows.


the problem is that my 2.5k rows takes 40 minutes to produce. The oracle dba will not supply the view sql, he will not let me build any temp tables or functions.

is there any other way I can speed this up ?

The DBA is either part of the solution, or part of the problem.

First, ask him how you can speed it up. Then at least you'll know which he is.

[EternalOptimist]

how long does a select on the view without linking to other tables take to run?

10 mins (ish)

[EternalOptimist]

The DBA is either part of the solution, or part of the problem.

First, ask him how you can speed it up. Then at least you'll know which he is.

we cant afford to pay him to be part of the solution

[Spacecadet]

The DBA is either part of the solution, or part of the problem.

First, ask him how you can speed it up. then you'll know which he is.

DBAs and specifically Oracle DBAs are always part of the problem. They seem to think that their job means stopping people from doing anything useful, rather than the reverse.
Typically the sort of person who WANTS to be a DBA should be the last person chosen for that role

[Spacecadet]

10 mins (ish)

ok - so its not the view holding thigs up

can you query the user_views table?

[Bob Dalek]

DBAs and specifically Oracle DBAs are always part of the problem. They seem to think that their job means stopping people from doing anything useful, rather than the reverse.
Typically the sort of person who WANTS to be a DBA should be the last person chosen for that role

Sadly often true. I'm an Oracle DBA and (cue Land of Hope and Glory on the gramophone) give the developers/whoever as much info. as I can (sensibly, of course) about queries, schemas, etc. Why the frig would I want to do the leg work? Your DBA is a tw@t.