Somebody probably wanted to see a solution (or solutions) without using them. IME, most of the stuff that is done with temp tables can be done without them and for a lot of dba's I've known over the years, temp tables are a no-no.
Temp tables is my bet.
Somebody probably wanted to see a solution (or solutions) without using them. IME, most of the stuff that is done with temp tables can be done without them and for a lot of dba's I've known over the years, temp tables are a no-no. |
|
Re: Temp tables is my bet.
Probably... temp tables can be performance killers, except when they aren't. I use a temp table only if the thing I'm doing is complex enough that the query optimizer can't handle it correctly, or if I'm reusing the results of an expensive query repeatedly. Regards, -scott Welcome to Rivendell, Mr. Anderson. |
|
Setting up temp tables correctly can be difficult.
At least in MySQL it is where there is a distinct permission for creating temporary tables but not for modifying them (such as adding keys). :-/ If the only permissions you have are Select and Create Temporary Table, you have to create a temporary table, index it and fill it with data all in one statement. That said, I am usually willing to explore options that require post-processing of the data. Some database programmers don't like that. Wade. Just Add Story http://justaddstory.wordpress.com/ |
|
If you guys say "table" one more time...
...particularly if you're looking in the mirror, he will appear. And tablize your face. |
|
:-)
|
|
Only an uns*table* person would think of it! :)
Alex "There is a cult of ignorance in the United States, and there has always been. The strain of anti-intellectualism has been a constant thread winding its way through our political and cultural life, nurtured by the false notion that democracy means that "my ignorance is just as good as your knowledge." -- Isaac Asimov |
|
Ahh.. The Green Table, then: you're a balletomane..
|