On 7/16/2014 1:40 PM, Sytze de Boer wrote:
After yesterday, with heart in mouth, I ask the following
I have a table with large amount of data
It contains Master contract, sub contract, sub-sub contract
pcode N(5)
pcode2 N(7)
pcode3 N(9)
Example
3770
3770, 377001
3770, 377001, 37700101
3770, 377001, 37700102
3770, 377002
3770, 377002, 37700201
3770, 377002, 37700202
When I do a select statement, I seem to get them in correct order with
select * from contract order by pcode,pcode2,pcode3 etc
But if I want to create an index, I lose my head.
Any pointers?
how about index on str(pcode, 5, 0) + str(pcode2, 7, 0) + str(pcode3, 9,
0) [to myindex.idx or tag mytag]
HTH
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/53c6e4f5.3090...@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.