Re: CREATE INDEX is very slow
Posted by:
Sal Young
Date: June 20, 2005 07:51AM
Field Type Null Key Default Extra
ITDetailID int(11) unsigned NO PRI
Firm char(2) NO MUL
ANumber char(12) NO MUL
CCode char(3) YES
AccountType char(1) YES
RType char(1) YES
SubType char(1) YES
PSIUC char(12) YES
Quantity decimal(19,5) YES
TPrinciple decimal(19,2) YES
TAmount decimal(19,2) YES
TInterest decimal(19,2) YES
TDate datetime NO
TNumber char(5) NO
BSCode char(1) YES
Description char(15) YES
Price decimal(19,10) YES
PrincipleNetCode char(1) YES
Withholding decimal(19,2) YES
oid_penalty decimal(19,2) YES
oid_withholding decimal(19,2) YES
MatureIndicator char(1) YES
State char(2) YES
Country char(2) YES
SecurityTypeCode char(3) YES
UserDefined char(12) YES
trd_oid_treas decimal(19,2) YES
Description1 char(30) YES
Description2 char(30) YES
MatDate datetime YES
CouponRate char(9) YES
Year char(4) YES
OriginalFileName char(10) NO MUL
Subject
Views
Written By
Posted
4913
June 17, 2005 01:58PM
3587
June 17, 2005 02:17PM
Re: CREATE INDEX is very slow
3625
June 20, 2005 07:51AM
3428
June 20, 2005 07:57AM
3507
June 20, 2005 08:19AM
10474
June 20, 2005 12:38PM
4213
June 20, 2005 04:22PM
3955
June 20, 2005 12:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.