 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Getting Started / July 2006MS 2000 Sql Index Hint In CFC Query
How do you force the query in your function (component) to use the Index created. If you have some thing like this select * from class and a bunch of where clauses. In Oracle you you can provide a hint. Does CF allow for this in the CFC's queries? any example? First it should automatically select the index. I would run it through query analyzer and see the exectution path. If you want to force and index.. select * from class with INDEX(index1,index2..) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.