| Author |
Message |
    
Sam
Yavvanam Kaatesina Bewarse
Username: Sam
Post Number: 3153
Registered: 03-2004
Posted From: 65.114.90.194
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 12:31 pm: |    |
<</*+ append parallel (xyzhold,12) */ >>
These are existing (user created) indecies for the table being used in select or insert or what ever... |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14744
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 11:29 am: | |
so adi user defined aa leka system defined aa sam mama...
same with parallel
for ex:
insert /*+ append parallel (xyzhold,12) */ into xyz_hold xyzhold (field1, field2, field3) select
/*+ parallel (x,12) */ xyz.field1, my_new_value_for_field2, xyz.field3 from xyz x
/*+ append parallel (xyzhold,12) */
are these user defined or system defined...
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Sam
Yavvanam Kaatesina Bewarse
Username: Sam
Post Number: 3150
Registered: 03-2004
Posted From: 69.212.213.152
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 11:23 am: | |
APPEND anedhi name of an index for the table being used....
aa query run chesetappudu ee index use chesthe performance baguntundhi anukunteee.. we use the hint (syntax: /*+ <<Index_Name>> */ ) . |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14743
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 11:21 am: | |
sam mama..
inkonchem detail ga kudirithe with example cheppava
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Sam
Yavvanam Kaatesina Bewarse
Username: Sam
Post Number: 3148
Registered: 03-2004
Posted From: 69.212.213.152
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 11:15 am: | |
<</*+ APPEND */ deeni purpose enti?>>
Daanni hint antaru... basically forcing the query to use particular index... |
Indiainfo
Celebrity Bewarse
Username: Indiainfo
Post Number: 14742
Registered: 03-2004
Posted From: 198.204.133.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 11:13 am: | |
insert /*+ APPEND */
into INVTMP
select *
from INVINS t1;
lo
/*+ APPEND */ deeni purpose enti?
what does that mean?
sam mama...
sql server no idea...
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu |
Sam
Yavvanam Kaatesina Bewarse
Username: Sam
Post Number: 3147
Registered: 03-2004
Posted From: 65.114.90.194
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 10:14 am: | |
yes maama |
Bumperless_toyota
Pilla Bewarse
Username: Bumperless_toyota
Post Number: 51
Registered: 10-2007
Posted From: 194.151.208.152
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 9:51 am: | |
SQL server aa
No Condom no fun, Know Condom know fun  .... |
Sam
Yavvanam Kaatesina Bewarse
Username: Sam
Post Number: 3144
Registered: 03-2004
Posted From: 65.114.90.194
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, November 07, 2007 - 9:19 am: | |
Star_FactsDetails a WITH (NOLOCK)
SalesMartPSEO_PROD.dbo.Sales_Star_Item e WITH (NOLOCK) ON (a.itemnumber = e.itemnumber
or a.RemarkExplanation = e.ItemNumber02
or a.RemarkExplanation = cast (e.itemnumber as Varchar) )
Eee query optomize cheyyali ante emi cheyyali....
If I change it to this: it is executing in 3minutes but the above query is taking more than 3hrs.....
Star_FactsDetails a WITH (NOLOCK)
SalesMartPSEO_PROD.dbo.Sales_Star_Item e WITH (NOLOCK) ON (a.itemnumber = e.itemnumber ) |
