Answer Detail: RE: how to choose between indexing and partitioning ,...

GeekInterview.com > Interview Questions > Oracle > Data Access

Print |

Question: how to choose between indexing and partitioning , to make query faster.

March 03, 2007 04:39:50	#1
praveenladdu1	Member Since: February 2007 Total Comments: 2
RE: how to choose between indexing and partitioning ,...
generally we use partinioning for large databases ( if a huge collection of data is there). indexing is the first most process to fast query result,