Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Faster access of data from views

Status
Not open for further replies.
AgentM

AgentM

MIS
Jun 6, 2001
387
US
I have a view whose columns are created from other views in the database.

The data retrieval is very slow because of these views.
Is there a way I can improve the access of data?

Any help is appreciated

 
Sort by date Sort by votes
Views of views confuse the Optimizer and it uses full table scans. Always try to make views from the under-lying tables. I tried to remain child-like, all I acheived was childish.
 
Upvote 0 Downvote
Thank you
I had the same view working fine a few days back. But suddenly it seems to be very slow.

Any other suggestions to improve the speed?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
798
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
757
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
235
TheLazyPig
TheLazyPig
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
296
Livia8
Livia8
mibeach7
  • Locked
  • Question
OEM extract ORA- from string text 1
Replies
2
Views
192
mibeach7
mibeach7

Part and Inventory Search

Sponsor

Back
Top