Home » RDBMS Server » Performance Tuning » select clause (10g)
select clause [message #435587] Thu, 17 December 2009 00:17 Go to next message
kish_ulike
Messages: 30
Registered: June 2008
Location: chennai
Member

I have a table with 1000 columns and with a primary key.
and data in the table are more than 500000 records.

If i give the select query with some where conditions(I have given possible where conditions required) it is taking much time to fetch the data.Can any one give suggestion
to perform efficiently.

Thanks
----------
Kishore
Re: select clause [message #435588 is a reply to message #435587] Thu, 17 December 2009 00:20 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Can any one give suggestion to perform efficiently.
SELECT uses INDEX to return 1 row.
Re: select clause [message #435594 is a reply to message #435587] Thu, 17 December 2009 00:34 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Kishore, think about the question you asked. You have basically said:
"I am doing something. It takes a long time. How can I make it faster"
You have given us basically NO detail that is useful.
Please read this very carefully and re-post your question with the appropriate information.

[Updated on: Thu, 17 December 2009 00:34]

Report message to a moderator

Previous Topic: grants running extemely slow
Next Topic: Queries in oracle indexing
Goto Forum:
  


Current Time: Sat Dec 03 12:29:09 CST 2016

Total time taken to generate the page: 0.09733 seconds