Re: Dynamically Adding an Index to a query

Josh Fraser wrote:

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 cannot add indices to a query.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: ERROR: Not enough space on temporary disk. WHY not?
    ... properly joined as seen below so that there isn't an outright Cartisian ... However you really don't know if there are multiple joins between ... query without the DISTINCT then insert the records from there. ... let the DB2 database do most of the work for you. ...
    (microsoft.public.access.queries)
  • RE: Records Missing from Report
    ... I think you've hit on the answer, Jerry. ... My query was built on another query ... which had multiple joins and one didn't have the right properties. ... Jerry Whittle, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Traversing Friends Graph - How does Friendster do it?
    ... Timin Uram wrote: ... > because of multiple joins, ... A similar query I tested on a shared hosting with a table ...
    (comp.lang.php)
  • query optimization
    ... If I have a query with multiple joins. ... How should I contract it for ... Start joining on the large table first and then ...
    (microsoft.public.sqlserver.server)