Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WHY is LogicalFile but not index?

Status
Not open for further replies.
jdu2006

jdu2006

Programmer
May 13, 2008
6
US
After switched a data file from using logical file to index, the sql process got tremendously slowed down ( the file has millions records). Why and how can I fix it?
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
241
prashant_0701
P
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
89
handle907
handle907
YuriyS.
  • Locked
  • Question
Index based on other existing index? 1
Replies
1
Views
75
johnherman
johnherman
Kuldeepg
  • Locked
  • Question
Timestamp_format is not libl function
Replies
1
Views
140
mikrom
mikrom
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
95
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top