How did "designing databases" get separated from "development" in the first place? DDL is as much "code" as C#, Java, T-SQL, whatever.

<rant>

Please, please, please people, please stop using abbreviations! Please...

Just lie on your resume.

j_e_o, that sounds like a programmer to me.

One term I just hate is software engineer. We're not engineers, nor do I think most of us would want to be.

Call me whatever you want. Call me Ishmael, but right now I'm a Business Intelligence Architect.

If the title is at all correlated to the money you get, then it's important....

Why not just create a view in the database?

Assuming, of course, that a single SELECT statement can do the job.

I think that MS's success is that they have the timeline first, then figure out what to fit into it.

The problem comes when the functionality and the delivery date are...

Is that from Sarbox directly? If so, then make...

People, the title was purposely misleading. It was intended to get you to question your assumptions.

How in the world would combining the roles of analyst and programmer cause Sarbox problems?...

An Oracle materialized view is really just that: a query whose results are stored in a table instead of disappearing into the ether. You can schedule to run on just...

Jeswanth Jaishanker (7/14/2010)

---

Dear Stephen,

How does this improve the query speed when the previous 3 hour sql and current 15 seconds sql actually querying different tables and views?

Wondering why your...

I think it was Mark Twain that said, to a man with a hammer, everything is a nail. While that's a funny saying, and all too true in the IT...

Ouais, j'en parles pas mal (j'l'ai appris au Québec)

vdn1986 (7/14/2010)

---

I am assuming that the transactions on the form are updating to the Oracle DB.

If users reload the data on the indexed view, wouldn't it be outdated? They may...

"Could we be looking forward to a follow-up article? I'd put up my hand as an interested party...."

Thanks. Maybe (from my perspective), some rules of thumb as to when to...

nsmith2 (7/14/2010)

---

While I like the out-of-the-box solution, I don't think the article lives up to the title, which includes, "How to Increase Query Speed". This article does not discuss that...