Fields indexing
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
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:
Aug 19, 2005 6:10 AM GMT
UPDATED:
August 19, 2005 9:18:46 AM GMT
RELATED QUESTIONS
- Get the latest unique entries for user ID in Access database
- Save high volume xml transactions to db
- sql update command to change text
- Data model for Custom fields and Custom forms.
- QMF issue
- Ways to handle Very Large Table
- LISTBOX
- Partitioning Tables
- Information Store Warnings
- Windows server 2003 domain controller installation
Answer Wiki:
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.
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.
0 pts.
To see other answers submitted to the Answer Wiki View Answer History.
