Fields indexing

0 pts.
Tags:
Oracle
Topic: SQL Question: My question is regarding fields indexing. My table named' K5Details' contains about 200,000 records and the response time to access this table is quite slow. What is the best way to index this table in order to get better response time To this table, I've created few indexes. The indexes are : IndexName Fieldname Position ----------------------------------------- K5BLNOLSTS BLNO 1 K5BLNOLSTS LIFESTATUS 2 K5DBLNO BLNO 1 K5DPID PID 1 K5DPIDSMARK PID 1 K5DPIDSMARK SMK_MARK 2 K5FIDBLSTS BLNO 1 K5FIDBLSTS FID 2 K5FIDBLSTS LIFESTATUS 3 K5DFID FID 1 K5LSTSFID LIFESTATUS 1 K5LSTSFID FID 2 Please advice
ASKED: August 19, 2005  6:10 AM
UPDATED: August 19, 2005  9:18 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

The table indexing comes to what columns require index. The where clause in DML statement is the first indicator what column or columns need to be indexed. If you have repeated the same set of columns then you might want to use concatenated index up to 5 columns.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following