JDE INDEX SELECTION TOOL

-

 Index Selection Tool

    Database administrators drop indexes from tables in a physical database to increase system performance. Instead of using the actual database application to drop table indexes, you can use the Index Selection Tool (P95150). 

   The advantage of using P95150 to drop indexes is that Oracle's JD Edwards EnterpriseOne keeps track of the indexes that are dropped, even if the indexes have been restored or rebuilt. 

      For example, during a software update, the system restores indexes to tables that are affected by the update. Typically, after an update, you would have to perform another analysis to determine the indexes that need to be re-dropped. However, JD Edwards EnterpriseOne retains this information so that you can easily find the indexes that were previously dropped, reducing the time it takes to drop the indexes again.


Note. P95150 should only be used by system administrators or database administrators. Use Security Workbench (P00950) to apply the proper security to this application.  

    The P95150 program enables you to locate and display the table indexes in a tree structure. You expand the tree to view and flag the indexes that you wish to drop. You can flag a single index or multiple indexes at a time. The P95150 program only allows you to drop indexes that are not unique or primary to the table since dropping these types of indexes would disrupt the integrity of the table.

      When you open a table in P95150, the program displays the table and all of its columns in a tree. Each item, or node, in the tree has an icon next to it. The Tree Node Key tab contains a description of each of these icons.

Dropping a Single Index from a Table

Access the Index Selection Tool form.
The instructions in this section assume that you have already selected a table and a specific data source from which you want to drop the table index.
  1. Expand the data source node to view the indexes for the table.
  2. To flag an index, select an index and then click the Flag/Unflag Index button.
  3. To drop a single index, select a flagged index and then click the Drop Single Index button.
  4. On Drop Single Index, click one of these options and then click OK:
    • Use proxy user and password
    • Specify user and password
       This option activates the Owner ID and Password fields, which you must complete before clicking OK.
  5. On the dialog box, click OK to continue. 

Refer Support doc 1114664.1 - E1: DB: How to Drop and Restore Indices for EnterpriseOne Tables Using P95150 for more information.


Comments

Post a Comment

Popular posts from this blog

Oracle Cloud Infrastructure(OCI) - Part2

-
Image
In my earlier post (OCI -Part1 ), we have gone through OCI basic details, let's dive deep more into it. Before that, we need to u nderstand the following concepts and terminology to help you get started with Oracle Cloud Infrastructure.  Note: OCI is re-branding of Bare Metal Cloud Service (BMCS) BARE METAL HOST Oracle Cloud Infrastructure provides you control of the physical host (“bare metal”) machine. Bare metal compute instances run directly on bare metal servers without a hypervisor. When you provision a bare metal compute instance, you maintain sole control of the physical CPU, memory, and network interface card (NIC). You can configure and utilize the full capabilities of each physical machine as if it were hardware running in your own data center. You do not share the physical machine with any other tenants. REGIONS AND AVAILABILITY DOMAINS  Oracle Cloud Infrastructure is physically hosted in regions and availability domains. A region is a localized geographic area, an...
Read more

Script to display the SQL text for a specific SQL_ID

-
--> Purpose:    Script to display the SQL text  for a specific SQL_ID. -->             It returns the SQL_TEXT. --> Parameters: sql_id --> To Run:     @sqltext.sql sql_id --> Example:    @sqltext.sql 27b3qfm5x89xn --> --> Copyright 2020@The Ultimate SQL Tuning Formula set echo off set define '&' set verify off define _sql_id=&1 set verify off set feedback off set linesize 200 set heading on set termout on col sqltext format a100 word_wrapped select  sql_text as sqltext from gv$sqltext where sql_id = '&_sql_id' order by piece; **************************************************************************************** --> Purpose:    Script to display the SQL text  for a specific SQL_ID. -->             It returns the SQL_TEXT. --> Caution:  ...
Read more

How to Change Your EnterpriseOne Environment Color

-
Image
Sometimes users start working and then forget which EnterpriseOne environment they are logged into. Can you tell which environment you are logged into? Luckily, there is a new UDC that allows you to change your EnterpriseOne environment color. You can now set up environments to be color-coded for when you need a clear visual distinction as to which environment you are logged into. This enables you to quickly identify the non-production environments by color. The new UDC is 98/CO and is available in EnterpriseOne Tools Release 9.2.4 with Applications Release 9.1 and 9.2. The image below shows the default EnterpriseOne environment color. However, you can easily change the color to reflect different environments. For example, DV could be red, PY could be green, and PD could be yellow, as shown below. To do so, just add a new row in the User Defined Codes section, enter the EnterpriseOne environment name and the HEX value of the color you want the environment to be, and ...
Read more