Re: Query Retrieval is slow

Hi ,

kindly ignore this as i found what i wanted from the BOL. I have just
found out that the query itself is quite fast after tracing thru the codes.
This query insert data into a temp table. The problem happens when the report
from MS Access is formatting the data not only from the temp table but also
SQL table.

How is it possible to create a ADO connection that can be used by ms access
report instead on relying on the odbc-linked table ?

tks & rdgs


maxzsim wrote:
>Hi ,
> I have checked using sp_statistics 'tablename' and found that there's no
>columns being declared with statistics .
>
> How does having a statistical column(s) help to improve performance ? i
>would have thought that having clustered/non-clustered index is able to
>improve query performance ?
>
>tks & rdgs
>
>>What can be done here is to ask your system dba whether the statistics
>>on the tables that the query uses is updated recently. In case they are
>[quoted text clipped - 15 lines]
>>because you will bypass the virtual table in Access, and will be using
>>sql server indexes automatically and server processor.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200511/1
.

Relevant Pages

  • Re: Leftmost column in an index
    ... That's one example where the optimizer creates these _WA% statistics to ... which is the cost of a table scan. ... But this query: ... >> would likely change to a table scan or clustered index scan. ...
    (microsoft.public.sqlserver.programming)
  • Re: Strange Cost Based Optimizer Decision Making
    ... The statistics on this table are 100% completely up to ... > I run an identical SELECT clause to the last query against this table. ... > the stats are fully up to date for LARGE_TABLE. ... compare that number with clustering factor and number ...
    (comp.databases.oracle.server)
  • Re: Planning multiple queries
    ... > so it seems to me a new plan should be prepared for the second query, ... If you submit them all in one batch, SQL Server generates a query plan ... If no statistics get updated as result of the query, ...
    (comp.databases.ms-sqlserver)
  • Re: Coincidences with Numbers and Names....Then and Now...Anyone?
    ... I can't work out how to quote a link to my original query. ... "Again I'm unclear which statistics you are referring to when you ... This isn't borne out by the FreeBMD statistics which show it has ...
    (soc.genealogy.britain)
  • Re: Index with strange statistics?
    ... It is true that the index has no appropriate statistics to make any ... because for this query the index cannot be seeked or partially scanned ... > contain the first column of the index which SQL Server can use for a index ... Therefore SQL Server can rely on the ...
    (microsoft.public.sqlserver.server)
Loading