hi
yup, index without a hint will force MSSQL to utilise the index, this comes in useful in cases where optimiser selects the wrong indexe. I do not think index hint serves any purpose from v3s3 onwards
regards
harry
Varden Morris [EMAIL PROTECTED] wrote:
I haven't checked but it should
hi
i did some testing and i have to take my words back.
index hint is useful when your query is using forceliterals and the data in the table is radically different to the data on which the statistics was updated.
regards
harry"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote:
hi
hi Varden, Anil
Just curious, is there any other place where the statistics can be updated?
regards
harryVarden Morris [EMAIL PROTECTED] wrote:
Hi Anil,
There is no problem with this. That's where itshould be done. You should setup a maintenance plan to do this on a weekly basis during off
]
www.bilisimanadolu.com
Varden Morris [EMAIL PROTECTED]
Sent by: Axapta-Knowledge-Village@yahoogroups.com
11.10.2005 02:06
Please respond to
Axapta-Knowledge-Village@yahoogroups.com
To
Axapta-Knowledge-Village@yahoogroups.com
cc
Subject
Re: [Axapta-Knowledge-Village]
SQL Index Statistics
I haven't checked but it should only be a hint. The database may or may not use it. I think I read in some documentation that "index" without the "hint" will force MSSQL to use the index."Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote:
hi
thanx for that. Since anil was asking whether
Hi Anil,
There is no problem with this. That's where itshould be done. You should setup a maintenance plan to do this on a weekly basis during off peak hours. The auto update feature of SQL may not update the statistics that frequently, that's why it is recommended to do it through a schedule
6 matches
Mail list logo