04-11-2007 1:28 AM
Can anyone tell me if it is allowed to change the standard index ERD in the VBAK table from "No database index" to "Index on all database systems"?
What are the consequences when this change is performed?
04-11-2007 6:17 AM
Hi...
You can change this ...
first open the table VBAK then press the indexes push button or
Got--> Indexes.
it will show you all the indexes available for VBAK.
then double click on the index that you want to change.
now the index will be opened in display mode.
now you can edit this index (press Display <-> Change button (Ctrl+F1) ).
Here you can change the index as you need and activate it.
( No need of any access key to change the index)
Let me know if you have any more doubt...
Reward points if useful......
Suresh....
04-11-2007 6:19 AM
Index will be created on DB server level , so eveny time when u are trying to access data of this table , based on the where clause this index will be used.
Regards
Prabhu
04-11-2007 6:25 AM
Hi....
Whether an index improves or worsens performance often depends on the database system. You can therefore set whether an index defined in the ABAP Dictionary should be created in the database.
If u select :
<b>Index in all database systems:</b> The index is always created in the database.
<b>No database index:</b> The index is not created in the database. If you
set this option for an index that already exists in the database, it
is deleted when you activate the table in the ABAP Dictionary.
Reward points if useful......
Suresh......
04-11-2007 8:18 AM
Thanks uys for you response.
i am able to create/modify index ERD from no-datase index to all database index.
BUT question is.
How will this degrade the performance in terms of inserting new vbak records in table.
will it slower future records in vbak.
04-11-2007 3:20 PM
Hi Sandeep,
Answer to your last question:
The creating or modifying index will in no way affect the performance of inserting new records into the VBAK table. Purpose of indexes is to read data faster hence it is independent of the process or performance of inserting data into the table.
Hence the performance of insertion will remain as it is.
Regards,
Shahu