It's your worst nightmare come true!!!
The users want to do it 'cause
a) IS charge to much for the work
b) All it is is a bunch of stuff in a big file thing, how difficult could it
be?
c) Isn't it just like a big spreadsheet only different?
d) I built one at home so I know what to look for (t
You kidding? That sounds like our developers.
Henry
-Original Message-
Sent: Monday, September 10, 2001 6:52 PM
To: Multiple recipients of list ORACLE-L
Hey all,
I just got out from a meeting where I was told that some of our users are
asking for a tool to do their own queries agai
There are products that can be used to enforce
what kind of queries run on your database.
Very expenive, lot's of setup. Some of you
may still be interested though.
www.teleran.com
Jared
On Monday 10 September 2001 17:40, Charlie Mengler wrote:
> Just be prepared to watch response time for h
Just be prepared to watch response time for honest OLTP work to increase
through the roof.
Almost daily I have adhoc query folks throw onto the DB a "query from
hades" which
result in 3 - 6 way cartesian joins of tables with hundred of millions
of rows EACH.
When the first query does not return re
G-d, yes, we have users like that. Most of the products we looked at
required too much space, were too expensive, or required too much initial
set up time. We ended up writing our own Adhoc Query tool in PowerBuilder.
At 02:52 PM 9/10/01 -0800, you wrote:
>Hey all,
>
>I just got out from a me
recommendation: ensure you give those users separate profiles/consumer
user group so they dont totally hog the machine with cartesian join
queries. :)
joe
Hey all,
I just got out from a meeting where I was told that some of our users
are asking for a tool to do their own queries against ou
We use Cognos as a user report
tool. They seem to like it. You can build a library of reports
for them or they can build their own.
Bad side . it does
not make the most efficient SQL calls.
-Original Message-From: Stephen Andert
[mailto:[EMAIL PROTECTED]]Sent: Mo