How to speed up Querying a a huge table

ramamoorthy · #1 (**permalink**) 07-15-09, 02:27

hi
if any one help How to speed up Querying a a huge table in oracle ?

shammat · #2 (**permalink**) 07-15-09, 02:45

Read the Performance tuning guide

Post the DDL of the table
Post the SQL of the query
Post the execution plan

The_Duck · #3 (**permalink**) 07-16-09, 15:08

define "huge"
is huge = # of rows?
is huge = size of table?

pablolee · #4 (**permalink**) 07-17-09, 07:56

Quote:

Originally Posted by ramamoorthy

hi
if any one help How to speed up Querying a a huge table in oracle ?

Buy a bigger server.

dav1mo · #5 (**permalink**) 07-17-09, 10:43

the fastest query is the one that does not run
Dave