Posted by maxzsim via SQLMonster.com on 11/25/05 02:29

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

[Back to original message]