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

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

VIPS wrote:
>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
>not, ask the dba to
>enable the statistics and create a job the will update statistics on a
>weekend when the server is not too busy.
>
>Another option is to use a query analyzer and see what the query plan
>is like. If the plan indicates that it is using a table scan, ask have
>the dba create relevant index on a table and update and set statistics
>on.
>
>On a side note, Access connection to Sql Server that you have is fairly
>easy to set up however the TABLE LINKING" method is the slowest as it
>hauls not just relevant records but a page amount of record at a time.
>
>If you can do your insert using Connection in the ADO in your forms, it
>would be the guaranteed fastest method without any doubt. This is
>because you will bypass the virtual table in Access, and will be using
>sql server indexes automatically and server processor.

--
Message posted via http://www.sqlmonster.com

[Back to original message]