Thread: What do you do for a living?
View Single Post
Old 08-23-2010, 06:43 PM   #254
meromana
Zealot
meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.meromana can tame squirrels without the assistance of a chair or a whip.
 
meromana's Avatar
 
Posts: 129
Karma: 11430
Join Date: Jun 2010
Location: NC, USA
Device: my laptop
Quote:
Originally Posted by GlenBarrington View Post
Chances are, your queries are accessing or joining on a column that has no statistics or indexes on it and forcing the parser to read every record in one or more tables and in HUGE tables, that can take some time.
Yes, this is exactly the problem. I am grouping on columns that are not indexed (the tables/views I query are all part of a database that's "in development"), but I have to use those columns, which is what I keep telling them. I didn't realize there was anything the DBA's might be able to do to help. I thought it was all up to the developers to do that stuff.

Well, thanks, maybe I will go ahead and ask for their help next time, instead of just being annoyed at them! Geez, you are threatening to change my whole perspective on DBA's.

And yes, we have thoroughly and completely derailed this very nice thread...

Maria
meromana is offline   Reply With Quote