Sytze: I've been surprised to find everyone works with a "large amount of data" but for some of us, that's thirty thousand records and for others it is thirty million.
INDEX ON pcode TAG pcode INDEX ON pcode2 TAG pcode2 INDEX ON pcode3 TAG pcode3 INDEX ON DELETED() TAG DELETED On Wed, Jul 16, 2014 at 4:40 PM, Sytze de Boer <sytze.k...@gmail.com> 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? > > -- > Kind regards, > Sytze de Boer > Kiss Software > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ 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/CACW6n4stwMw=bVUV7fTD=kF4LpMPZ5b2pxXAtun8VyyS=5b...@mail.gmail.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.