on 01-26-2010 6:28 AM
各位大侠!
请问能不能按照某些特性来给CUBE单独创建INDEX?
还想问一下,在CUBE里创建的INDEX(通过CUBE管理提供的工具创建的INDEX),怎么通过T-CODE来察看?
祝好!
谢谢 各位打侠的热情回复!
VINCE LU 我们系统的数据库是 ORACLE 版本: 10.2.0.4.0
谢谢 fanchest meng
谢谢 kai zhang 不过你告诉我的方法,只是创建INDEX,这样的创建是默认给所有
dimension ID 创建,现在我希望单独给某个特性创建在CUBE中.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
cube 是通过dimension table和master table 连接的,用listschema可以看到cube下所有的F表和D表,然后SE11 对应的表,可以看到系统自动为这些表创建的索引。你要为某个IO创建索引,可以找到这个IO所在的Dimension 表,然后SE11看到系统默认会为这个IO已经在D表里面创建好索引了,如果没有,你可以直接在上面创建。
Cube无法直接针对IO,除非你讲Dimension定义为 line item,这样D表存的直接是SID,也间接等于直接为这个IO创建了索引.
还有就是你甚至可以在DB level为你想要的任何字段创建索引,这个已经是DBA的操作了,数据库性能优化。
Vince Lu
非常感谢您及时热情的回复!
非常感谢!
您的建议非长有用!
祝好!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
fanchest meng
非常抱歉,我会在 VINCE LU 回复后,将分数补回
真的很抱歉!
我希望您能就QUERY的查询性能提出一些建议,非常感谢您的热情回复!
祝好!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
VINCE LU
我特别想听听您的意见,关于我的这个问题.
并且希望您提供一些BW查询性能优化的建议.
非常感谢!
所以,我将这个帖子设置成为 未解决. 请谅解!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Index can be created by managing a cube. There are two types of indexes. They are primary index and secondary index.
Primary index is automatically created by the system ie system generated index.
Secondary index is created by us.
Indexing is a process of storing data according to an index
like in a phone book.Secondary indexes are of bit map and
binary tree.
To create a Secondary Index,
1.Select your data target(Infocube or DSO)and select context
menu and select Manage.
2. Select the Performance tab and select 'Create Index' button.
3. In the new dialog box, Select 'Selection' and then select
'Immediate' and click Save.
4. Select 'Start' and click 'Continue'.
Once the Secondary Index is created, a check mark is created
in front of the data target.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
cube 会默认给所有的dimension ID创建索引,你可以通过se11->cube FACT表名,在index那就可以看到所有的索引。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi, 先请问一下您的DB是什么? oracle, DB2/6 还是sqlserver?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.