Indexes missing in the database

[Former Member]

hello gurus

Missing indexes. Check of 23.04.2007 20:11:16

Indexes missing in the database

Primary indexes 0

Secondary indexes 6

/BIC/F100067-160

/BIC/F100067-150

/BIC/F100067-140

/BIC/F100067-130

/BIC/F100067-120

/BIC/F100067-110

This is my problem, I am facing in my database, can somebody help me to understand what is Primary indexes, Secondary indexes in the database

whether they critical or non critical, what is the process so that we can rectify the

indexes ?

Waiting for your reply

Thank You

[Former Member]

Thanks

[Former Member]

99% of secondary indexes cause just performance issues and it will not affect the database completely.These are non critical ones. But escalate it to bw team to fix the problem.

[Former Member]

Hi,

these are secondary indexes for aggregate fact tables in BW.

ask your BW guys to check this aggregate (100067) and ask them to check the underlying cube (can be found in field INFOCUBE of tbl RSDDAGGRDIR with AGGRCUBE = 100067);

you should not bother too much with these kind of index; just notify; the BW team will fix it by creating indexes for this cube or reactivate this aggregate.

hope this helps,

Olivier.

Message was edited by:

Olivier Cora

[Former Member]

HI Shishir,

<b>Here are the definitions for the following :</b>

<b>Missing indexes</b> may occur if you ignore an error message when creating a table (table created, index not created) or if an index is deleted. The latter case may occur during an incorrect reorganization.

<b>Difference between Primary and Secondary Index:</b>

<b>Primary indexes</b> (ending with 0) ensure that the line keys (row keys) are unique. Missing primary indexes are therefore a critical problem.

<b>Secondary indexes</b> (ending with 0) are used for particular scans and are only important for performance.

To analyze the above use T-code DB02

Regards

<b>Vijay Kothapalli</b>

[former_member204746]

talk to your BW functional, it is his responsibility to create those indexes.

[Former Member]

Hi Shishir,

Go to Db02>missing indexes>Primary indexes 0

Secondary indexes 6

/BIC/F100067-160

/BIC/F100067-150

/BIC/F100067-140

/BIC/F100067-130

/BIC/F100067-120

/BIC/F100067-110

Select the missing index and click on <b>Create inDB</b> icon then a Popup box araises select background processing type and click on <b>Create</b>

regards,

kanthi