Re: Dynamically Adding an Index to a query

Josh Fraser schrieb:
Hey all,

I have a very complex ado query (80 columns) with multiple joins.

I would really like to be able to dynamically add index's to the query. Is this possible to do ?

Josh

You should take a look at Indexed Views (SQL Server) or Materialized Views(Oracle).
Not dynamic but maybe that's something you could use here.

Ralf
.