 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / October 2004FTS ON View in Yukon ?
I am eargerly awaiting my MSDN Universal, until then I am very interested to know if Yukon will allow a View to be FT Indexed ? I am working on a scenario right as we speak that may be worth pushing off for the moment if SQL 2005 Will support these Anyone ? Or do I just need to jump through the hoops as I would have before ? Chris My understanding is that only tables are indexable in Yukon. >I am eargerly awaiting my MSDN Universal, until then I am very > interested to know if Yukon will allow a View to be FT Indexed ? I am [quoted text clipped - 6 lines] > > Chris Chris, Yukon (SQL Server 2005) will support FT Indexing on Partition Views, i.e.. materialized views and not "normal" views. See SQL 2000 BOL title "CREATE VIEW" for more information on Partition Views. Is this type of view possible in your scenario? Thanks, John > I am eargerly awaiting my MSDN Universal, until then I am very > interested to know if Yukon will allow a View to be FT Indexed ? I am [quoted text clipped - 6 lines] > > Chris Hmm, I dont think so, as my data cannot really be represented how the Local Partitioned Views require but I will look into it further, thanks Chris > Chris, > Yukon (SQL Server 2005) will support FT Indexing on Partition Views, i.e.. [quoted text clipped - 15 lines] > > > > Chris You're welcome, Chris, While I need to confirm this with the SQL Server 2005 (Yukon) Community Technology Previews (CTP) releases (post-Beta2 releases), it is possible that some of the restrictions on Indexed (or Materialized) view might be relaxed in Yukon, relative to SQL Server 2000 (Sphinx). Regards, John > Hmm, I dont think so, as my data cannot really be represented how the > Local Partitioned Views require but I will look into it further, [quoted text clipped - 21 lines] > > > > > > Chris |
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.