Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2012 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through September 12, 2012 * Sql Query Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 750
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:24 pm:    Edit Post Delete Post Print Post


Gochi:



nope for example

mary ani undi anukoo

mar isthee mar tho vchee results ani kavaalanataa..

ilemaa report genrate chesukovochugaa.. ala desgn sesaru page nii
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 78654
Registered: 07-2004
Posted on Tuesday, September 11, 2012 - 3:20 pm:    Edit Post Delete Post Print Post

aina query lo like @firstname + '%' ani endukettaaru...is it like they are concatenating % to what they are passing from front end..
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 749
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:20 pm:    Edit Post Delete Post Print Post


Firefox:




tried ..not working..

Contains use chesaa where caluse lo ..
\problem entante it would ftech in a paragraph text ..rather than jusr name search
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 748
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:19 pm:    Edit Post Delete Post Print Post


Gotcha:




indexes craeet chesanu annay
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 485
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 3:15 pm:    Edit Post Delete Post Print Post

if that didn't help, since last name is unique, apply even that to composite index you created before with 3 columns and see.
Top of pagePrevious messageNext messageBottom of page Link to this message

Firefox
Pilla Bewarse
Username: Firefox

Post Number: 771
Registered: 12-2004
Posted on Tuesday, September 11, 2012 - 3:13 pm:    Edit Post Delete Post Print Post

edo full text search anta with -
CONTAINS or FREETEXT

Comparing LIKE to Full-Text Search

In contrast to full-text search, the LIKE Transact-SQL predicate works on character patterns only. Also, you cannot use the LIKE predicate to query formatted binary data. Furthermore, a LIKE query against a large amount of unstructured text data is much slower than an equivalent full-text query against the same data. A LIKE query against millions of rows of text data can take minutes to return; whereas a full-text query can take only seconds or less against the same data, depending on the number of rows that are returned.

http://msdn.microsoft.com/en-us/library/ms142571.aspx
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 484
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 3:10 pm:    Edit Post Delete Post Print Post

create a composite index with these three columns and see


pro.default_location
pro.org_id
completed_indicator
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 747
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:10 pm:    Edit Post Delete Post Print Post

query leepsaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 746
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:10 pm:    Edit Post Delete Post Print Post


Gotcha:




yes..again where clause is applied to view.. we will get reuslts which we dont want ..edi think sesina idea vachi savataledhu
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 483
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 3:05 pm:    Edit Post Delete Post Print Post

indexed view is not the solution. if your table is indexed your view results will be same as your table scan results.
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 745
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:05 pm:    Edit Post Delete Post Print Post


Gotcha:




adi antha sesakee... Like seraches are killing ani conclusion kochaa u r honor
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 744
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:05 pm:    Edit Post Delete Post Print Post


Godfather:




Anni sesanu annay..

daniki like tesey ..ventane result vastahdi antee like kavalantandii .. ayithe dobichukoo ani sepdamanukuntunaa//sava thenksiyoo ilemaaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 482
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 3:04 pm:    Edit Post Delete Post Print Post

first make sure all these columns are indexed:

pro.first_Name
pro.last_name
pro.default_location
pro.org_id

Second,
Run the queries individually without join and see how long it takes.
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 68013
Registered: 03-2004
Posted on Tuesday, September 11, 2012 - 3:04 pm:    Edit Post Delete Post Print Post

Query analyzer use sessi soodu emana help avutundi emo..CLIPART--angel_grinning
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 743
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 3:00 pm:    Edit Post Delete Post Print Post


Nalla_baalu:




anthaka mundu 180 lines undi..nenu dani e range ki tesukochaaa ..

ayyinaa musaladi sava thenkuthundii ..anthaka mund 20 mins run ayedi ippudu 5 mins..daniki 1 sec lomkavalaantaaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 742
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:59 pm:    Edit Post Delete Post Print Post


Godfather:




Indexed View would be faster..

kaani limitations unte seppu
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu

Post Number: 8795
Registered: 06-2011
Posted on Tuesday, September 11, 2012 - 2:59 pm:    Edit Post Delete Post Print Post

endadhi query naaa developing ki ichina code aaa
Aug 11th weight -- 84 kg \bemmi.muniga icon
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 68012
Registered: 03-2004
Posted on Tuesday, September 11, 2012 - 2:56 pm:    Edit Post Delete Post Print Post

Yea indexed view annee.. Normal view aite peddaga help vundadu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 741
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:54 pm:    Edit Post Delete Post Print Post

annay like columns are killing i am sure
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 481
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 2:49 pm:    Edit Post Delete Post Print Post

while joining the results to another table use the pk column.

No way the search will be 5 minutes if it is just a simple table with 2 million and column is indexed.

now you are saying there is a join, so aa logic kuda post, idea cheputa. it must be the join which is causing the issue
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 739
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:48 pm:    Edit Post Delete Post Print Post


Godfather:




view inka slow kadehee .. ?indexed view mind lo undi..but datawarehousing vadathanu adi..adi ela pani setahdoo telidu
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 738
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:48 pm:    Edit Post Delete Post Print Post

Ma company co director anta sava thenkuthundi..musali mndaaa ..i want asap antadi.. MOVIEART--bemmi.lungi
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 737
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:47 pm:    Edit Post Delete Post Print Post


Gotcha:




pk is an ident column. but the search is on name .. and results are joined to other table .. thats having another million recoerds
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 736
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:46 pm:    Edit Post Delete Post Print Post


Gotcha:




yes indxed..covering index add chesanu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 735
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:46 pm:    Edit Post Delete Post Print Post


Gochi:




I am sure its beacuse of like
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 480
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 2:45 pm:    Edit Post Delete Post Print Post

your search will be faster if there is primary key or other indexed column in your search. what is the primary key of this table?
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 479
Registered: 01-2007
Posted on Tuesday, September 11, 2012 - 2:43 pm:    Edit Post Delete Post Print Post

is first name column indexed?
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 68011
Registered: 03-2004
Posted on Tuesday, September 11, 2012 - 2:42 pm:    Edit Post Delete Post Print Post

Essay type setta vundu..MOVIEART--kota.kick
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 68010
Registered: 03-2004
Posted on Tuesday, September 11, 2012 - 2:40 pm:    Edit Post Delete Post Print Post

Direct table meeda query kante.. View create chesi try cheyi..
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu

Post Number: 8794
Registered: 06-2011
Posted on Tuesday, September 11, 2012 - 2:40 pm:    Edit Post Delete Post Print Post


Godfather:

Joins vunnaya or else single table?


rendu cases lo emaithaayo cheppandi for furture reference
Aug 11th weight -- 84 kg \bemmi.muniga icon
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 68009
Registered: 03-2004
Posted on Tuesday, September 11, 2012 - 2:33 pm:    Edit Post Delete Post Print Post

Joins vunnaya or else single table?
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 78653
Registered: 07-2004
Posted on Tuesday, September 11, 2012 - 2:26 pm:    Edit Post Delete Post Print Post


Lenevo:

gochi annay .. main aim is to restrict table/index scan .. from lo nuvvu chepiantu chesina like wll do all the search




true...but I just want to confirm if this like is what is killing the whole thing...ippudu subquery lo raasukuni kooda work avvakapothe then we are 100% sure its because of this...lekapothe it can be 100 different reasons kadhaa ani...the way other indexes are working etc

ippudu like ki choodaam em cheyyaalo
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma

Post Number: 22111
Registered: 06-2004
Posted on Tuesday, September 11, 2012 - 2:26 pm:    Edit Post Delete Post Print Post


Nalla_baalu:

annai movers dhi oka manchi suggestion ivvandi ...austin to minneapolis moving friends telisina vaalu




naaku peddaga theledu kani oka friend NC nunchi dallas move ayyadu. 900 ani chivaraki 1300 ala chesadu anta bill. it is excluding car. inti samanu. sofa, beds etc ki. athanu ippudu sleep lo undi untadu. evening call chesi cheptha.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 78652
Registered: 07-2004
Posted on Tuesday, September 11, 2012 - 2:25 pm:    Edit Post Delete Post Print Post


Lenevo:

this is in sql server basically




SQL Server anta bemmam baa
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 734
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:24 pm:    Edit Post Delete Post Print Post

gochi annay .. main aim is to restrict table/index scan .. from lo nuvvu chepiantu chesina like wll do all the search
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 733
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:23 pm:    Edit Post Delete Post Print Post


Gochi:




doesnt help bro//Like, kills where ever you use
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu

Post Number: 8793
Registered: 06-2011
Posted on Tuesday, September 11, 2012 - 2:20 pm:    Edit Post Delete Post Print Post


Ravanabrahma:


annai movers dhi oka manchi suggestion ivvandi ...austin to minneapolis moving friends telisina vaalu
Aug 11th weight -- 84 kg \bemmi.muniga icon
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Celebrity Bewarse
Username: Ravanabrahma

Post Number: 22110
Registered: 06-2004
Posted on Tuesday, September 11, 2012 - 2:19 pm:    Edit Post Delete Post Print Post


Lenevo:




http://www.dba-oracle.com/oracle_tips_like_sql_index.htm

MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 78651
Registered: 07-2004
Posted on Tuesday, September 11, 2012 - 2:17 pm:    Edit Post Delete Post Print Post

pedda query lo where clause lo pass chesthunnaaru kadhaa like '%..' ani...

alaa kaakundaa what if you pass the filter in the From clause...does it improve performance

Original Query:

select * from a,b,c,d
where a.name like 'Sachin%'

New Query:

select * from
(select a.* from a where name like 'Sachin%') a
b,c,d
Top of pagePrevious messageNext messageBottom of page Link to this message

Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa

Post Number: 21721
Registered: 03-2008
Posted on Tuesday, September 11, 2012 - 2:09 pm:    Edit Post Delete Post Print Post


Lenevo:

edo oakti seppi savu.. ida sava nookuthundi idii


sever ni oka paali vonchi mallaa restart cheyyi....
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 732
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 2:05 pm:    Edit Post Delete Post Print Post


Jaffaa:




edo oakti seppi savu.. ida sava nookuthundi idii MOVIEART--bemmi.lungi
Top of pagePrevious messageNext messageBottom of page Link to this message

Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa

Post Number: 21720
Registered: 03-2008
Posted on Tuesday, September 11, 2012 - 2:02 pm:    Edit Post Delete Post Print Post

table drop chesi empty table create cheyyi...fast ga vosthayi resultsMOVIEART--bemmi.sarle
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 731
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 1:58 pm:    Edit Post Delete Post Print Post


Symbol_of_king:




Thanks bro.. i think this wil effect other queries..any way let me try that
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 730
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 1:58 pm:    Edit Post Delete Post Print Post

this is in sql server basically
Top of pagePrevious messageNext messageBottom of page Link to this message

Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king

Post Number: 2112
Registered: 12-2005
Posted on Tuesday, September 11, 2012 - 1:57 pm:    Edit Post Delete Post Print Post

naku book knowledge tapithe realtime implementation experience ledu index partioning meeda...so just sharing info..see below links

http://stackoverflow.com/questions/1358490/is-a-globally-partitioned-index-bette r-faster-than-a-non-partitioned-index

http://stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/partconc.htm
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 729
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 1:45 pm:    Edit Post Delete Post Print Post


Symbol_of_king:




Index partitoning ??

migatha queries effect padda?? while using that index ??
Top of pagePrevious messageNext messageBottom of page Link to this message

Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king

Post Number: 2111
Registered: 12-2005
Posted on Tuesday, September 11, 2012 - 1:44 pm:    Edit Post Delete Post Print Post

"like" ni replace cheyyalemu anukunta...may be "range index partitioning" will help..i am not sure
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 728
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 1:43 pm:    Edit Post Delete Post Print Post

Konchem urgent idi.. emi anukokunda sodi anukokundaa .. emanna telisthee plzz kindly help brothers
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 727
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 1:34 pm:    Edit Post Delete Post Print Post

I am thinking to add another column to serach first_name easily..but what taht column should be ?? how tp figure out .. anedi ardam kataledhu ...

what if i add a bitmap columna and then serach with bit operator ??? will that help

any one have an idea with bitmap ??
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 726
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 1:33 pm:    Edit Post Delete Post Print Post


Symbol_of_king:




Index doesnt help//Like is searching for entire indexes and table..
Top of pagePrevious messageNext messageBottom of page Link to this message

Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king

Post Number: 2110
Registered: 12-2005
Posted on Tuesday, September 11, 2012 - 1:28 pm:    Edit Post Delete Post Print Post

http://laurentschneider.com/wordpress/2009/07/how-to-tune-where-name-likebc.html

google search lo edi vachindi...may be it will help you
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Yavvanam Kaatesina Bewarse
Username: Nalla_baalu

Post Number: 8792
Registered: 06-2011
Posted on Tuesday, September 11, 2012 - 1:17 pm:    Edit Post Delete Post Print Post

bump
Aug 11th weight -- 84 kg \bemmi.muniga icon
Top of pagePrevious messageNext messageBottom of page Link to this message

Lenevo
Pilla Bewarse
Username: Lenevo

Post Number: 725
Registered: 05-2011
Posted on Tuesday, September 11, 2012 - 12:43 pm:    Edit Post Delete Post Print Post

I have table named person ..
columns

First_name,
last_name ,
address,
etc ;

ippudu problem antantee.

First_name like + '%' vadathanaru query loo..

and its searching for all the table..

Tables has 2 million rows and this is OLTP not olap..

Query taking 5 mins to execute it has other joins as well.. first_name = ani isthe < 1 sec lo vasthundii ..like rasam kabati taking time..

I checked indexes, statistics etc all Dba tasks from my end ..

fast ga ela rayaloo kodiga sepundrii

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration