Re: Dynamically Adding an Index to a query

Yeah thats what I thought Bill.

Ralf, thats an interesting suggestion, the main reason why I really need an index is because I am exporting the query to a dbf table, and the app that uses that dbf table requires the index. Ah well back to the drawing board.

Josh

Ralf Jansen wrote:
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
.

Relevant Pages

  • Re: Make Table Name Parm
    ... we then burn the .dbf files along with others to a cdrom and provide them ... I called it with this query code... ... > ITSELF* knows nothing about Excel or exporting. ...
    (microsoft.public.access.queries)
  • RE: Help with importing
    ... Dim strFullName As String ... Dim dbf As Database ... The make it an Append Query. ...
    (microsoft.public.access.modulesdaovba)
  • DBF linked tables
    ... We have FoxBASE program that would still have helping to run the information ... We linked the DBF table in to the new environments on Ms Access XP. ... The only problem that we have now is the speed when Ms Access query is ... Let say, that we have two DBF tables linked in to the access environment, we ...
    (microsoft.public.access.queries)
  • Re: is it worth creating multiple indexes?
    ... Keep in mind that indexes won't help during retrieval if the query optimizer ... > from a DBF background where one needed indexes on ... > bother with creating anything but a primary key". ... > a split sec when I use these secondary DBF indexes. ...
    (microsoft.public.sqlserver.msde)
  • OleDB provider not using index
    ... I've got a large FoxPro table that I'm trying to query from an ASP.NET ... When I open the .dbf in FoxPro, ... using the .dbf file as the source in the connection string ...
    (microsoft.public.fox.vfp.dbc)