Haven't found it.
Does DB2 LUW Enterprise 9.7 have indexed views?

Or if not, is there likely idea in a near future version?



Thanks for any feedback.

/long-time DBA, now knee-deep in DB2...

Views are the virtual tables and therefore using the indexes of the tables which consist in create views statements.

Lenny

You can achieve the functionality similar to MS SQL Server indexed views by creating DB2 materialized query tables and building indexes upon them.

that's something to consider, thanks much.

MQT is NOT a VIEW. You have to execute REFRESH TABLE mqt_tbl
before retrieve information from mqt_tbl table.

Lenny

But that's not the point of what I'm going after, whether something is a literally a view or not.
But something that allows me to apply indexing to standing SQL statements to potentially optimize the performance of its results.
Not guaranteed, but I'm trying to consider my options and think outside the box.

MQT, Materialized View, Indexed View...

I believe the gentleperson's answer gave me an option to the situation that was inferred in the question.

But thanks for the input, I do appreciate it.

rogue49
Location: Near D.C
- or -
DMV?

Live MD of the DMV was VA
Work DC...I'd tell you where, but I'd have to kill you.

MQT is working faster than view (with the same structure), but REFRESH could take a long time.

Lenny

Both these statements, like all hasty generalizations, may prove incorrect under certain conditions.

Everything is possible !

Lenny

Another hasty generalization.

You only have to explicitly issue the refresh one time (right after you create the MQT) if you define the MQT as system maintained. Thereafter, DB2 will automatically keep the MQT in synch with the base table. Obviously, you might not want an MQT to be system maintained if there were a lot of changes being made to the base table and the MQT was a summary table.