Hi
I have made an observation regarding the use of index and
index hint in the Axapta application of one of our
customers.
Axapta 2.5 MP3SP3 and MS SQL.
The customer upgraded to a new version of the MSSQL.
(Upgrading from MSSQL Server 7.0 to MSSQL Server 2000)
Running MSSQL 7.0 the use of index worked fine in a
specific select statement.
After the upgrade this specific select statement seemed to
take forever to execute.
Changing to index hint made the select statement run
quickly like it used to on MSSQL 7.0.
Also simply removing the use of index/index hint made it
run quickly.
Seems to me that in this case it matters what
MSSQL version is running Axapta.
Regards
Svein T. Hansen
Fra: HEW (Mag. Helmut Wimmer) [mailto:[EMAIL PROTECTED]
Sendt: 11. februar 2004 11:24
Til: '[EMAIL PROTECTED]'
Emne: RE: [development-axapta] Index & Index Hint - Oracle / MSSQL
You are right. "Index" and "Index hint" will produce a simple "index"
statement when you are using MSSQL. There is no difference between the two
then. For Oracle, it's another story.
BTW: Sometimes it is better not to assign an "index" command at all. Let the
MSSQL figure out the best index. Normally it will find the best one. (That's
a thing somebody told me that was part of the programming team of MSSQL 2K
server).
-----Urspr�ngliche Nachricht-----
Von: Rudi Hansen [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 06. Februar 2004 15:02
An: [EMAIL PROTECTED]
Betreff: [development-axapta] Index & Index Hint - Oracle / MSSQL
How is it with the index & index hint options.
It it correct that index hint is the same as index on MSSQL but on Oracle
index hint is really a hint?
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/saFolB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
