Patrick.I (2/8/2011)

---

Hi All,

I have a .NET app and the app uses a Oracle Db.So i'm using Oracle .Net Provider for .NET

I have a problem with...

Please do. Every decent rdbms has this feature nowadays, SQL Server calls it "Plan Guides", Oracle calls it...

Oracle documentation is free so, when in doubt RTFM 😉

Here http://www.oracle.com/pls/db102/portal.all_books

Just bing: sql server job offers xxxxxx

where: xxxxx = australia, bahamas, virgin...

That's why God created forums ...

YSLGuru (2/7/2011)

---

Paul - I...

sqlgreg (2/7/2011)

---

I need to query a production Oracle 9i database. I will be selecting all columns from a table that has about 10 million rows.

Unfortunately, there is not a test...

You are absolutely correct - I shouldn't be posting on Friday afternoon 🙂

...and the other way is Plan Guides; check link on my previous post 😉

Let me translate, compatibility level will affect query behavior in the sense that query optimizer will be limited to the "compatibility level" you have set, it will not use any...

brucecphillips (2/5/2011)

---

Any help is appreciated, I'm relatively new to this.

I am moving data from a large warehouse (hundreds of billions of rows) that I will be using for later analysis.

I...

AND 😉

YSLGuru (2/5/2011)

---

Is it possible in SQL 2005 to over ride the use of a specific index without disabling the index?

After some testing over time I've narrowed done the problem with...

Behaviour is there to deal with...

Yash Ganthe (2/4/2011)

---

We have a very large table on which there is no PK. For some reason there is a clustered index on the table defined on the columns which...