2013年3月8日
摘要: OracleAL16UTF16:Varchar2(N char) == Nvarchar(N) in SQL ServerVarchar2(N) ==Nvarchar(2*N) in SQL ServerOracleAL32UTF8:Varchar2(N char) == Nvarchar(3*N) in SQL ServerVarchar2(N) ==Nvarchar(3*2*N) in SQL Serverhttps://forums.oracle.com/forums/thread.jspa?threadID=709453&tstart=98&messageID=2788 阅读全文
posted @ 2013-03-08 10:52 庖丁解牛 阅读(158) 评论(1) 推荐(0) 编辑
摘要: 1. After creating index, there will be a statistics generated.2. After dropping the index, the statistics will be dropped together.When the clustered index of an indexed view is dropped, all nonclustered indexes and auto-created statistics on the same view are automatically dropped. Manually created 阅读全文
posted @ 2013-03-08 10:07 庖丁解牛 阅读(134) 评论(0) 推荐(0) 编辑