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)
 Optimizer

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2003-09-23 : 18:21:07
Hi,
How do I know if my db is set to rule or cost based optimizer?
Thanks,
Sarat.

**To be intoxicated is to feel sophisticated, but not be able to say it.**

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-23 : 18:27:34
That setting does not apply to SQL Server. It is a Oracle setting, at least as far as I know.

Tara
Go to Top of Page

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2003-09-23 : 18:34:26
I thought so, we deal with Query Optimizer! Thanks for the quick response!
Sarat.

**To be intoxicated is to feel sophisticated, but not be able to say it.**
Go to Top of Page
   

- Advertisement -