renathy Posted November 25, 2009 Report Share Posted November 25, 2009 Man ir db tabulā lauks - parasti kādi 30-40 simboli. Ļoti bieži tiek meklēti dati pēc šī lauka sākuma. Piemēram, SELECT * FROM tabula WHERE lauks like 'Abr%' Piemēram, SELECT * FROM tabula WHERE lauks like 'Ca%' utt. Tā kā datu ir daudz, tad kā es saprotu, būtu labi kādu indeksu pielikt uz šī lauka. Kādu indeksu lietderīgi šādam gadījumam? R. Quote Link to comment Share on other sites More sharing options...
briedis Posted November 25, 2009 Report Share Posted November 25, 2009 (edited) Lauks ir unikāls? Unique indekss? Varbūt tas lauks raksturo tabulas ierakstus? Primary key ? Kāds ir lauka tips? Edited November 25, 2009 by briedis Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.