SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need suggestion on adding Index on table

Sudhir_MeruMay 29 2012 — edited May 29 2012

Hi,

There is table called customer_locations in my database which has records about more then 5000 rows, When we write some select query to fetch data from this table takes too much time to load the data.

Need a suggestion how to add index to increase the performance on this table. also which type of index to be added need a suggestion

table sql script is mentioned below

CREATE TABLE "CUSTOMER_LOCATIONS"
( "LOCATION_ID" NUMBER NOT NULL ENABLE,
"COMPANY_NAME" VARCHAR2(512),
"ADDRESS_LINE_1" VARCHAR2(512),
"ADDRESS_LINE_2" VARCHAR2(512),
"PHONE_NUMBER" VARCHAR2(255),
"FAX_NUMBER" VARCHAR2(255),
"CITY" VARCHAR2(512),
"STATE" VARCHAR2(512),
"ZIP" VARCHAR2(100),
"COUNTRY" VARCHAR2(255),
"CREATED_BY" VARCHAR2(512),
"CREATED_DATE" TIMESTAMP (6),
"MODIFIED_BY" VARCHAR2(512),
"MODIFIED_DATE" TIMESTAMP (6),
"DOMAIN_ID" NUMBER,
"LOCATION_TYPE" VARCHAR2(255),
"STATUS" VARCHAR2(50),
"IB_STATUS" VARCHAR2(100),
"OLD_LOCATION_ID" VARCHAR2(50),
CONSTRAINT "SS_CUSTOMER_LOCATIONS_PK" PRIMARY KEY ("LOCATION_ID") ENABLE
)
/

Please suggest

Thanks
Sudhir

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2012

Added on May 29 2012

6 comments

361 views