sql server - File table with clustered index -


i have read through available documentations file table on sql server. 1 thing has not mentioned creating additional indexes (non-unique clustered index in case) on file table fixed schema.

am right fine , wouldn't cause issues? if issue best approach?

according create, alter, , drop filetables topic in sql server documentation (emphasis mine):

since filetable has pre-defined , fixed schema, cannot add or change columns. however, you can add custom indexes, triggers, constraints, , other options filetable.

so should fine adding custom indexes.


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -