YARDIMCI PRG. EK REHBER

Merhaba arkadaslar.
yardimci prog. ekrehberden bir rehber olusturdum. tblcasabit-tblsthar-tblfatirs-tblcarikod1-tblcarikod2-tblcarikod3-tblcarikod4-tblstokkod1-
tblstokkod2-tblstokkod4-tblstokkod5-tblstsabirek-tblstgrup-tblstsabitek-tbliskontip den çalisiyor ve rehberde arama islemi yaparken çok yavas çalisiyor yani cari ismi yazarken harfler ekrana çok yavas düsüyor. Bu rehberi nasil hizlandirabiliriz. Rehberde arama kisitlarindaki yavaslik sorunundan baska bir sorunu yok çok güzel çalisiyor. Bakmak isteyen olursa viewi gönderebilirim. Her sirketin derdine derman olacak bir bir view benim isimi mükemmel görüyor.

merhaba (sa) üstad, msn e atiyorum. kolay gelsin.

günaydin cagatay,
view cümle asagida
_____________________________________________________________________
SELECT     dbo.STHAR.SUBE_KODU, dbo.STHAR.STOK_KODU, dbo.STSABIT.STOK_ADI, dbo.STSABIT.GRUP_KODU AS SGRUP_KODU,
                      dbo.STGRUP.GRUP_ISIM AS SGRUP_ISIM, dbo.STSABIT.KOD_1 AS SKOD_1, dbo.STOKKOD1.GRUP_ISIM AS SKOD1_ISIM,
                      dbo.STSABIT.KOD_2 AS SKOD_2, dbo.STOKKOD2.GRUP_ISIM AS SKOD2_ISIM, dbo.STSABIT.SATICI_KODU, dbo.STHAR.STHAR_ACIKLAMA,
                      LEFT(dbo.CASABIT.CARI_ISIM, 25) AS MUSTERI, dbo.CASABIT.CARI_TIP, dbo.CASABIT.GRUP_KODU AS CGRUP_KODU,
                      dbo.CASABIT.RAPOR_KODU1 AS CKOD_1, dbo.CARIKOD1.GRUP_ISIM AS CKOD1_ISIM, dbo.CASABIT.RAPOR_KODU2 AS CKOD_2,
                      dbo.CASABIT.CARI_IL, dbo.CASABIT.CARI_ILCE, dbo.STHAR.STHAR_HTUR, dbo.STHAR.STHAR_KOD1, dbo.STHAR.STHAR_KOD2,
                      dbo.STHAR.STHAR_TARIH, RIGHT(dbo.STHAR.FISNO, 10) AS FAT_NO, dbo.STHAR.AMBAR_KABULNO, dbo.STHAR.IRSALIYE_NO,
                      dbo.STHAR.STHAR_ODEGUN, dbo.STHAR.STHAR_BF, dbo.STHAR.STHAR_NF, dbo.STHAR.STHAR_IAF, (dbo.STHAR.STHAR_BF - dbo.STHAR.STHAR_NF)
                      * dbo.STHAR.STHAR_GCMIK AS ISKONTOTUT, dbo.STHAR.STHAR_SATISK * 100000 AS ISK_1, dbo.STHAR.STHAR_MALFISK, dbo.STSABIT.OLCU_BR1,
                      dbo.STSABIT.OLCU_BR2, dbo.STSABIT.OLCU_BR3, (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS GIRISM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS GRISIM2,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS GIRISM3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_NF AS NETGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_BF AS BRUTGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_IAF AS IADEGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS CIKISM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS CIKISM2,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS CIKISM3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_NF AS NETCIKISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_BF AS BRUTCIKISTUT,
                      dbo.STHAR.STHAR_KDV, dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS KDV_TUT,
                      dbo.STHAR.STHAR_SIPNUM, dbo.STHAR.STHAR_DOVFIAT, dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_DOVFIAT AS DOVIZ_TUTARI,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_GIRIS_MIKTAR,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_CIKIS_MIKTAR,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS ALIS_TOPLAM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS SATIS_TOPLAM, dbo.STHAR.CEVRIM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN (STHAR.CEVRIM * STHAR.STHAR_GCMIK * STHAR.STHAR_NF) ELSE 0 END) AS BEKLEME_ADATI,
                      dbo.STSABITEK.TUR, dbo.STSABITEK.MGRUP AS MRUP, dbo.STSABITEK.INGISIM, dbo.STSABITEK.KULL1N, dbo.STSABITEK.KULL2N,
                      dbo.STSABITEK.KULL1S, dbo.STSABITEK.KULL2S, dbo.STHAR.DEPO_KODU, dbo.STHAR.PROMASYON_KODU, dbo.STHAR.BAGLANTI_NO,
                      dbo.STHAR.VADE_TARIHI, dbo.STHAR.LISTE_NO, dbo.STHAR.LISTE_FIAT, dbo.CARIKOD2.GRUP_ISIM AS CKOD2_ISIM,
                      dbo.STHAR.PLASIYER_KODU AS PLAS_KOD, dbo.STHAR.PROJE_KODU, dbo.STHAR.EKALAN_NEDEN, dbo.STHAR.EKALAN,
                      dbo.STHAR.EKALAN1 AS EKALAN2, dbo.STHAR.MUH_KODU AS MUHKODU, dbo.PROJE.PROJE_ACIKLAMA,
                      ISKONTIP1.ACIKLAMA AS ISKONTO1_ACIKLAMA, ISKONTIP2.ACIKLAMA AS ISKONTO2_ACIKLAMA, ISKONTIP3.ACIKLAMA AS ISKONTO3_ACIKLAMA,
                      (CASE WHEN (STSABIT.B_YEDEK7 = 1) OR
                      (STSABIT.B_YEDEK7 = 2) THEN 'E' ELSE 'H' END) AS KITSTOGU,
                      (CASE WHEN STHAR.L_YEDEK9 = - 1 THEN 'K' ELSE (CASE WHEN STHAR.L_YEDEK9 > 0 THEN 'B' ELSE 'N' END) END) AS KITHAREKETI,
                      dbo.STSABIT.KOD_3 AS KOD3, dbo.STSABIT.KOD_4 AS KOD4, dbo.STSABIT.KOD_5 AS KOD5, dbo.CASABIT.RAPOR_KODU3 AS CKOD_3,
                      dbo.CASABIT.RAPOR_KODU4 AS CKOD_4, dbo.CASABIT.RAPOR_KODU5 AS CKOD_5, dbo.STHAR.YAPKOD,
                      CASE WHEN STSABIT.YAPILANDIR = 'E' THEN DBO.NSF_YAPACIK(STHAR.YAPKOD, STOKPARAM.C_YEDEK8, ESNYAPMAS.YAPACIK) ELSE NULL
                      END AS YAPACIK, dbo.CASABIT.CARI_ADRES, dbo.STHAR.STHAR_SATISK2, dbo.STHAR.STRA_SATISK3, dbo.STHAR.STRA_SATISK4,
                      dbo.STHAR.STRA_SATISK5, dbo.STHAR.STHAR_GCKOD, dbo.STSABIT.PAY_1, dbo.STSABIT.PAYDA_1
FROM        dbo.STHAR INNER JOIN
                      dbo.STSABIT ON dbo.STHAR.STOK_KODU = dbo.STSABIT.STOK_KODU INNER JOIN
                      dbo.NETCONTEXT ON 1 = 1 INNER JOIN
                      dbo.TBLSTOKPARAM AS STOKPARAM WITH (NOLOCK) ON STOKPARAM.ISLETME_KODU = dbo.NETCONTEXT.V$ISLETME_KODU LEFT OUTER JOIN
                      dbo.STGRUP ON dbo.STSABIT.GRUP_KODU = dbo.STGRUP.GRUP_KOD LEFT OUTER JOIN
                      dbo.CASABIT ON dbo.STHAR.STHAR_ACIKLAMA = dbo.CASABIT.CARI_KOD AND dbo.STSABIT.SUBE_KODU = dbo.CASABIT.SUBE_KODU INNER JOIN
                      dbo.STSABITEK ON dbo.STSABIT.STOK_KODU = dbo.STSABITEK.STOK_KODU LEFT OUTER JOIN
                      dbo.STOKKOD1 ON dbo.STSABIT.KOD_1 = dbo.STOKKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.CARIKOD1 ON dbo.CASABIT.RAPOR_KODU1 = dbo.CARIKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.CARIKOD2 ON dbo.CASABIT.RAPOR_KODU2 = dbo.CARIKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.STOKKOD2 ON dbo.STSABIT.KOD_2 = dbo.STOKKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.PROJE ON dbo.STHAR.PROJE_KODU = dbo.PROJE.PROJE_KODU LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP1 ON dbo.STHAR.SATISK1TIP = ISKONTIP1.ISKONTOTIP LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP2 ON dbo.STHAR.SATISK2TIP = ISKONTIP2.ISKONTOTIP LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP3 ON dbo.STHAR.SATISK3TIP = ISKONTIP3.ISKONTOTIP LEFT OUTER JOIN
                      dbo.TBLESNYAPMAS AS ESNYAPMAS WITH (NOLOCK) ON ESNYAPMAS.YAPKOD = dbo.STHAR.YAPKOD

tesekürler aygumus kardes,
ileriye dönük bir düsünce ile biraz da netsisin kendi viewinden faydalanarak hazirlamistim.

dbo.NETCONTEXT ON 1 = 1  niye kullaniyorsunki...

SELAM EMINAY KARDESIM FAZLA BI BILGIM YOK KUSURA BAKMA BU WIEW I REHBER OLUSTURMADA NEREYE YAPISTIRIYORUZ ACABA

Düzenleyen CAGATAY - 28 Eylül 2007 Saat 12:29

merhaba üstad,
merhaba kusura bakmayin pc'mde ag sorunu olustu her cevap vermeye çalistigimda ag koptu. ancak düzeltebildim.
ek rehberde yapistirma yapilmiyor, view tablo çagiriliyor. rehberdeki her alan için inset tusu kullaniliyor.