what does the terminology Expensive refer to

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

what does the terminology Expensive refer to

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-10-01 : 13:26:59

Hi,
They talk a lot about expensive/Cheap in sql admin, what s that mean?

P.S: I hope they re not talking about buying bread and egg and doing groceries :)

Thanks, Gracias

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-01 : 13:29:04

I have no idea what you are referring to. Could you put the terms in perspective for us?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 13:30:47

I talk about Cheap and Expensive queries, and for me that means the amount of Resource/time/CPU/etc. that the Query will take.

I can perhaps make a query "cheaper" by optimising it.

Kristen

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-10-01 : 15:24:08

expensive = more money
cheap = less money

CODO ERGO SUM

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 15:26:46

Client pay me $MegaBucks and I convert their Expensive queries into Cheap ones