| select clause [message #435587] |
Thu, 17 December 2009 00:17  |
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 #435594 is a reply to message #435587] |
Thu, 17 December 2009 00:34  |
pablolee
Messages: 2882
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
