September 3, 2010 at 1:11 am
Lynn Pettis (9/2/2010)
IIRC, it is actually a myth that Oracle runs better with loops and cursors. Perhaps I'll have the opportunity to verify that well written set-based queries run better than cursor-based queries.
Some things simply can't be done set-based in Oracle. Triggers, for instance, have to process modified rows RBAR.
However, in my short and far from deep experience, the set-based strategy works better even in Oracle.:-)
-- Gianluca Sartori
September 3, 2010 at 1:31 am
Gianluca Sartori (9/3/2010)
Some things simply can't be done set-based in Oracle. Triggers, for instance, have to process modified rows RBAR.
Probably just as well - most people struggle to write set-based trigger logic anyway.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 3, 2010 at 2:04 am
Paul White NZ (9/3/2010)
Gianluca Sartori (9/3/2010)
Some things simply can't be done set-based in Oracle. Triggers, for instance, have to process modified rows RBAR.Probably just as well - most people struggle to write set-based trigger logic anyway.
You mean the trigger isnt fired for each and every row ? Damn 😀
September 3, 2010 at 3:16 am
Dave Ballantyne (9/3/2010)
Paul White NZ (9/3/2010)
Gianluca Sartori (9/3/2010)
Some things simply can't be done set-based in Oracle. Triggers, for instance, have to process modified rows RBAR.Probably just as well - most people struggle to write set-based trigger logic anyway.
You mean the trigger isnt fired for each and every row ? Damn 😀
The other thing I see quite often is a trigger that *prevents* multi-row changes (by raising an error).
A total admission of failure.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 3, 2010 at 4:43 am
Yesterday I had a wild argument with my boss, claiming that a column named "description" could be perfectly suitable for a foreign key.
I had to leave the office and go home to avoid killing him with my pocket pork-chop launcher.
Now I will probably get fired because I left the office without his permission.
It's a sad, sad world.
I only hope I will soon find a better place to work.
-- Gianluca Sartori
September 3, 2010 at 5:01 am
Make it "foolproof" and they'll come up with a better fool 😀
Thumbs up for the new job ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 3, 2010 at 5:18 am
Gianluca,
A column named description is a great candidate for a foreign key, so long as the column is extremely poorly named 😀
Work sucks doesn't it? You won't miss it.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 3, 2010 at 7:08 am
Gianluca Sartori (9/3/2010)
Yesterday I had a wild argument with my boss, claiming that a column named "description" could be perfectly suitable for a foreign key.I had to leave the office and go home to avoid killing him with my pocket pork-chop launcher.
Now I will probably get fired because I left the office without his permission.
It's a sad, sad world.
I only hope I will soon find a better place to work.
Some people just don't seem to get it, do they.
First, I hope you don't get fired.
Second, if you are looking for a new opportunity, I hope you find it soon. I think even I might have a problem working with your boss.
September 3, 2010 at 7:56 am
Lynn Pettis (9/3/2010)
Gianluca Sartori (9/3/2010)
Yesterday I had a wild argument with my boss, claiming that a column named "description" could be perfectly suitable for a foreign key.I had to leave the office and go home to avoid killing him with my pocket pork-chop launcher.
Now I will probably get fired because I left the office without his permission.
It's a sad, sad world.
I only hope I will soon find a better place to work.
Some people just don't seem to get it, do they.
First, I hope you don't get fired.
Second, if you are looking for a new opportunity, I hope you find it soon. I think even I might have a problem working with your boss.
I would have a hard time working with that boss too!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2010 at 8:26 am
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
September 3, 2010 at 8:28 am
Steve Jones - Editor (9/3/2010)
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
And don't forget the satisfaction of 'I told you so...' 😀
Far away is close at hand in the images of elsewhere.
Anon.
September 3, 2010 at 8:29 am
Steve Jones - Editor (9/3/2010)
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
With a big phat I told you so
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2010 at 8:32 am
Any that are interested, my UG is having another livemeeting on Sep 9, 2010 @ 6PM PST.
https://www.livemeeting.com/cc/UserGroups/join?id=C7N873&role=attend
Meeting ID is C7N873 (just in case you need it).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 3, 2010 at 8:44 am
Steve Jones - Editor (9/3/2010)
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
Don't forget to document whose idea it was.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 3, 2010 at 8:53 am
Steve Jones - Editor (9/3/2010)
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
Well, our argument went a bit far from where it started, so it's not a FK issue any more.
Now the problem is that I am "unable to collaborate with my co-workers" because I point out the mistakes they make.
It's "impossible to talk constructively" to me, because I don't accept the other people's opinions.
My first IT employer 10 years ago sent all the new employees to a "enterprise culture" course. I don't know if this is the right translation, but I'm sure you get what I mean.
One of the most important things I learned there was the right way to criticize and accept criticism.
When you find something that you think is wrong, you can't criticize the person, but you always have to criticize the work he did.
When somebody criticizes your work, you don't have to identify yourself with it. Nobody's calling you idiot, they're just saying you did a mistake.
When I say that a FK on description cannot be made and is plain wrong, this is what I mean. I'm not calling names.
And, no, I can't accept other opinions on this. People like Codd and Boyce spent their whole lives on this: don't tell me you can do better than them.
Aw, crap! Sorry for the rant...
-- Gianluca Sartori
Viewing 15 posts - 18,106 through 18,120 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply