TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Karthik K
1k
742
193.3k
How to get Record faster from large Volume Data? In Oracle
Apr 11 2014 7:37 AM
Hi To All,
I Had a situation get the Customer Record so fast .I have using Asp.net and and Back End Oracle.My desire is get the customer Record according to the customer phone..I had two PhoneNo Column ,,,When i search single mobile no its give the record fastly.if i check the Cell_No number for the search its getting lot more time to fetch the record Provide me the Right solution for this issue.
Table structure :
cust_Details :
Phone_No numeric
Cell_NO Numeric
Adress Varchar2(50)
query 1: select * from view1 where Phone_No=9943540365
Faster One
query 2: select * from view1 where Cell_NO=9962840365
Slower One
Thanks in advance
Karthik.k
Reply
Answers (
0
)
Problem with Date datatype in oracle
problem with procedures ( select query and cursors ) Oracle