var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: what kind of index
I have 20 tables (the same schema)
I use view to search it with union operator.
now i have indexes on all of the tables on 1 kolumn (nvarchar)
what kind of index i should use to make it fastest
index on view ?
If your application needs to access views often, consider adding an unique clustered index to your views to significantly improve performance.
unfortunetly it's not unique field
is it good solution to build clustered indexes on all 20 tables
and next clustered index on view ?
Clustered index on all the tables will have definetly advantage, and if the space is not a concern then go for it.
Indexed view is also another addition to gain the performance.
Test it yourselves by creating both seperately and check the preferences.