Tema: Re: T-SQL OR vs IN
Autorius: Laimis
Data: 2009-11-16 17:34:22
ledasl rašė:
> execution planas toks pats, bet tik tiek. Pabandzius praktiskai
> pasimato, kad OR grandine uzklausa pas mane atliekama 6 kartus greiciau,
> nei IN.

Pasakei kažką panašaus: jei eglutė žalia, tai tik tiek, kad ji žalia, 
nes praktiškai, tai ji raudona...

p.s. sparta negali skirtis (ypač tai drastiškai), jei execution planai 
vienodi.
+T-SQLGintautas2009-12-02 23:28
+VB prisiloginimas prie tinklo pc ir exe paleidimasDarius2009-12-02 20:46
+Printer usagebertas2009-12-02 09:57
+Programuotojo praktika kaunerobertas2009-12-01 18:15
+Klausimas apie Delphino_leg2009-11-29 17:43
+Server resources requirement analizeJornada Del Muerto2009-11-27 12:57
rrdtoolLiofka2009-11-27 09:26
+Tai, aišku, gana intymu...Laimis2009-11-27 07:37
+Studijavimo laikas, darbo valandos ar laisvalaikis.IF2009-11-26 15:09
+Remote control softwareMaar2009-11-25 20:31
titanium ecm2001 crack torrent rapidshare download free EW.cyn=la!ecm2001 winols cpwin rapidshare torrent<ecm2001.winols@free-downloads.com>2009-11-23 21:37
+Oracle 10g R2 arba 11g ir object typeVitoldas2009-11-23 14:44
+"Try count" per PKCSRJ2009-11-23 14:29
+ClickOnce & CrystalReports deploymentJornada Del Muerto2009-11-20 16:08
+Visual Studio ir regionaiJornada Del Muerto2009-11-19 18:23
+VS2010 Framework 4IF2009-11-19 15:04
+Javascript helpzvaigzdzius2009-11-19 13:46
+Del LazarusE-Zyz2009-11-19 12:11
+Klausimas apie C#Saulius2009-11-18 02:00
+PropertyGrid Dynamic content ComboBoxJornada Del Muerto2009-11-17 14:57
+Q: VFP "release windows"Pilas2009-11-17 11:46
+pagalbos su Microsoft VBAUR1MA52009-11-17 10:18
+.NET klasesSaulius2009-11-16 11:23
titanium ecm2001 crack torrent rapidshare download free r,vceLPMHZecm2001 winols cpwin rapidshare torrent<ecm2001.winols@free-downloads.com>2009-11-14 21:06
+C# : anonymous methods ?Saulius2009-11-14 00:25
+Go languageArtūras Šlajus2009-11-13 20:57
-T-SQL OR vs INbala nemate2009-11-12 21:16
Re: T-SQL OR vs INVyvIT2009-11-13 18:31
Re: T-SQL OR vs INLaimis2009-11-13 18:55
Re: T-SQL OR vs INledasl2009-11-16 10:12
Re: T-SQL OR vs INLaimis2009-11-16 17:34
Re: T-SQL OR vs INledasl2009-11-16 21:50
Re: T-SQL OR vs IN@work2009-11-16 12:26
Re: T-SQL OR vs INJornada Del Muerto2009-11-16 13:24
Re: T-SQL OR vs INrl2009-11-16 12:12
Re: T-SQL OR vs INbala nemate2009-11-15 21:37
Re: T-SQL OR vs INIF2009-11-16 09:37
Re: T-SQL OR vs INLaimis2009-11-16 17:35
Re: T-SQL OR vs INIF2009-11-16 18:16
Re: T-SQL OR vs INLaimis2009-11-16 19:01
Re: T-SQL OR vs INIF2009-11-16 19:26
Re: T-SQL OR vs INLaimis2009-11-16 19:46
Re: T-SQL OR vs INIF2009-11-16 21:08
Re: T-SQL OR vs INLaimis2009-11-16 21:59
Re: T-SQL OR vs INIF2009-11-17 00:56
Re: T-SQL OR vs INLaimis2009-11-17 18:31
Re: T-SQL OR vs INIF2009-11-12 21:53
Re: T-SQL OR vs INbala nemate2009-11-13 17:21
+REQ: suma zodziasi PascalScript kalbaMinVodai2009-11-12 15:03
+ dash instead of bashAMB2009-11-12 11:32
+HASPAlita2009-11-11 22:55
+Q: Rip Audio CD [LT]?zZz2009-11-11 16:08
+anglisk buhalteriniaii terminainetikras2009-11-11 09:19
+Parekomenduokit C# knyguValdas2009-11-10 11:32
+Q: sector offset [LT]?zZz2009-11-09 16:48
+Kas turit excel'i paskaiciuokiteLwJ2009-11-09 13:36
FF ir screen capturerisflegmatoid2009-11-09 13:28
+Q: HTML/CSS: Skrolinamo div'o foninis paveiksliukas irgi skrolinasiGiedrius II2009-11-07 22:35
+kas naudoja network?Aurimas2009-11-06 12:37
+Laiko planavimasTrolis2009-11-05 11:23
+OpenOffice ODF ir kitos DBVSJornada Del Muerto2009-11-04 18:36
+REQ: suma zodziais latviskaispeed2009-11-02 16:36
+Excel drop down listai is lentelesYZF2009-11-01 15:03
telnet clientas per delphiAMB2009-11-01 12:20
+Q: all in one (auto update, online licencing, instaliation maker)news.omnitel.net2009-10-30 11:33