niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle
Parallel Hint
Post new topic   Reply to topic Page 1 of 1 [1 Post] View previous topic :: View next topic
Author Message
mail2jerry@gmail.com
*nix forums beginner


Joined: 07 Feb 2006
Posts: 3

PostPosted: Thu Jul 20, 2006 6:38 pm    Post subject: Parallel Hint Reply with quote
Hi,

Can someone tell me the difference between the following two usages of
paralle hint?

1. select /*+ PARALLEL*/ * from emp;
2. select /*+ PARALLEL(t,default)*/ * from emp t;

The degree of emp table is 1.

Both queries appear to generate differnt SQLs when it spawns threads.

Thanks
Jerry
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [1 Post] View previous topic :: View next topic
The time now is Mon Dec 01, 2008 7:52 pm | All times are GMT
navigation Forum index » Databases » Oracle
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Bug#379104: ITP: complearn-mpi -- parallel quartet tree s... Rudi Cilibrasi devel 0 Fri Jul 21, 2006 11:30 am
No new posts Dead parallel port (/dev messup) kaczfan hardware 4 Wed Jul 12, 2006 5:10 pm
No new posts Problem: no parallel in /dev Squark Setup 4 Mon Jul 10, 2006 10:47 pm
No new posts parallel query prasath.rao@gmail.com Oracle 13 Mon Jul 10, 2006 1:39 pm
No new posts parallel port programming simple problem Marco C 23 Mon Jul 10, 2006 2:32 am

YouTube Proxy | Loan | Personal Finance | Gas Suppliers | Mortgages
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.3010s ][ Queries: 16 (0.2320s) ][ GZIP on - Debug on ]