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.
