How to query works fastest

[ootkhopdi]

hello..

when i m using an select query to my data base . it runs too much slow..
it takes hours to complete function.. my data having app- 100000 records..

please tell me how can i run it faster ...
without break my data into other tables...
thanks

 

[jdraw]

Show us the SQL of the query and the table designs including indexing.