Hi,
There is a concept called INDEXTYPE in Oracle, Is there any equivallent for the same in SQL Server ?
Oracle example :
CREATE INDEX index1 ON test_table(col1) INDEXTYPE IS CTXSYS.CONTEXT
What is the SQL Server equivalent query for the above ?
Thanks,
SamI'm not enirely sure as to what exactly indextypes in Oracle are. As far as I know its a more narrow definition of how the column/s in the index could be used in when/like clauses and is build to that. Searches such as when client = 'Kaiowas', like 'Kai%s' or 'K%w%s'. Ms SQLServer does not have this kind of performance tuning as far as I know, perhaps Ms SQLServer depends more on it's internal query-plans.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment