09-25-2009, 04:18 PM
|
#1
|
|
Powerplay Quarterback
Join Date: Apr 2006
Location: Wherever you go there you are.
|
Evolution of a coder
__________________
Tacitus: Rara temporum felicitate, ubi sentire quae velis, et quae sentias dicere licet.
|
|
|
|
The Following User Says Thank You to Cliche For This Useful Post:
|
|
|
09-25-2009, 04:25 PM
|
#2
|
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Yes, I own this shirt.
http://www.thinkgeek.com/tshirts-app...ent/595d/zoom/
I got it for my birthday 3 years ago and it was interesting trying to explain it to the waitresses at Hooters.
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
|
|
The Following 5 Users Say Thank You to Bobblehead For This Useful Post:
|
|
|
09-26-2009, 11:51 AM
|
#3
|
|
Powerplay Quarterback
Join Date: Apr 2006
Location: Mahogany, aka halfway to Lethbridge
|
The only quibble I have is that the true Junior High program would have been as follows:
10 PRINT "HELLO WORLD"
20 GOTO 10
30 END
After which you run the program on your school computer lab and leave it running. Since the computer teachers at the time barely understand how typewriters work, let alone computers...
... Profit!
__________________
onetwo and threefour... Together no more. The end of an era. Let's rebuild...
|
|
|
|
|
09-26-2009, 01:22 PM
|
#4
|
|
Scoring Winger
|
That SELECT statement's not good. It's going to result in a table scan.
Last edited by Jedi Ninja; 09-26-2009 at 01:25 PM.
|
|
|
|
|
09-26-2009, 04:17 PM
|
#5
|
|
Powerplay Quarterback
Join Date: Mar 2006
Location: Trapped in my own code!!
|
They left out the part where you take the code, scramble the names, format the code to one line and commit it to production code.
|
|
|
|
|
09-27-2009, 10:29 AM
|
#6
|
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Quote:
Originally Posted by Jedi Ninja
That SELECT statement's not good. It's going to result in a table scan.
|
Not if you put the correct index on clue and have your statistics up do date.
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
|
|
09-29-2009, 08:23 AM
|
#7
|
|
First Line Centre
Join Date: Nov 2006
Location: /dev/null
|
What did one regex say to the other?
.+
|
|
|
|
|
09-29-2009, 08:24 AM
|
#8
|
|
First Line Centre
Join Date: Nov 2006
Location: /dev/null
|
Quote:
Originally Posted by Bobblehead
Not if you put the correct index on clue and have your statistics up do date.
|
Who cares? Server speed is the IT guys job, not the developers 
|
|
|
|
|
09-29-2009, 08:26 AM
|
#9
|
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Quote:
Originally Posted by llama64
Who cares? Server speed is the IT guys job, not the developers |
I'll give you a hint: /*+ index(emp_alias ix_emp) */
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
|
|
09-29-2009, 02:27 PM
|
#10
|
|
It's not easy being green!
Join Date: Oct 2001
Location: In the tubes to Vancouver Island
|
Ugh.. you guys are such nerds.
__________________
Who is in charge of this product and why haven't they been fired yet?
|
|
|
|
|
10-01-2009, 02:56 PM
|
#11
|
|
First Line Centre
Join Date: Nov 2006
Location: /dev/null
|
Quote:
Originally Posted by kermitology
Ugh.. you guys are such nerds.
|
I muss up my hair and use a Mac to code.
I'm a geek, tyvm.
|
|
|
|
|
10-01-2009, 03:07 PM
|
#12
|
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Quote:
Originally Posted by llama64
I muss up my hair and use a Mac to code.
I'm a geek, tyvm.
|
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
|
|
10-01-2009, 03:16 PM
|
#13
|
|
First Line Centre
Join Date: Nov 2006
Location: /dev/null
|
Quote:
Originally Posted by Bobblehead
|
Nono, Mac people are above smug - we smarm.
|
|
|
|
|
The Following User Says Thank You to llama64 For This Useful Post:
|
|
|
10-01-2009, 04:12 PM
|
#14
|
|
First Line Centre
Join Date: Mar 2009
Location: Brisbane, Australia
|
Quote:
Originally Posted by Jedi Ninja
That SELECT statement's not good. It's going to result in a table scan.
|
I'd use an OLAP cube to filter the clue dimension.
Last edited by Mad Mel; 10-01-2009 at 05:42 PM.
Reason: typing didn't keep up with brain
|
|
|
|
|
10-01-2009, 09:52 PM
|
#15
|
|
Scoring Winger
|
Quote:
Originally Posted by Mad Mel
I'd use an OLAP cube to filter the clue dimension.
|
I'm no DBA, but I think the most efficient and simplest way to tackle this problem is to create a table called Users_With_Clue (and move Clue into that table) and do an inner join against the Users table. As the Users_With_Clue table will always be empty, you'll get the fastest execution times on that SELECT statement plus save the overhead of having to maintain the index. You'll also save all that space you're wasting storing all those zero values, for that matter.
I'm sure this is why the Hooters waitress was confused by the shirt.
Last edited by Jedi Ninja; 10-01-2009 at 09:57 PM.
|
|
|
|
|
The Following User Says Thank You to Jedi Ninja For This Useful Post:
|
|
|
10-02-2009, 12:44 PM
|
#16
|
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Quote:
Originally Posted by Jedi Ninja
I'm no DBA, but I think the most efficient and simplest way to tackle this problem is to create a table called Users_With_Clue (and move Clue into that table) and do an inner join against the Users table. As the Users_With_Clue table will always be empty, you'll get the fastest execution times on that SELECT statement plus save the overhead of having to maintain the index. You'll also save all that space you're wasting storing all those zero values, for that matter.
I'm sure this is why the Hooters waitress was confused by the shirt.
|
While you have a point, a bitmap index on the column and you'll be fine without needing to code a join. And that column will probably be filled with null which won't take up any space; so unless you've set your pct_free/pct_used really wacky there won't be much chance of chained rows. Sometimes we DBAs need to denormalize to keep things easy for the code monkeys maintain the data structure.
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -6. The time now is 05:03 PM.
|
|
