|
|
Posted by Steven on 07/03/07 06:05
Don Burleson said in SQL Server2005, several new features are
introduced include function based index.( Specialised index on a
computed column (ala Function based Index))
But when I refered MSDN, I could't find this new function.
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON <object> ( column [ ASC | DESC ] [ ,...n ] )
[ INCLUDE ( column_name [ ,...n ] ) ]
[ WITH ( <relational_index_option> [ ,...n ] ) ]
[ ON { partition_scheme_name ( column_name )
| filegroup_name
| default
}
]
[ ; ]
What should I if I want to create index like this:
CREATE INDEX IDX1 ON T1(COL1+COL2-COL3)
Navigation:
[Reply to this message]
|