Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: INDEXTYPE equivalent ?

    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,
    Sam

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    I'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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •