topic Re: INDEX OR BUFFER in Application Development and Automation Discussions

INDEX OR BUFFER

Former Member — Sat, 28 Jun 2008 09:33:13 GMT

Hi all,

please tell me when is it efficient to use INDEX and will we use BUFFERING?

Anirban Bhattacharjee

Re: INDEX OR BUFFER

Former Member — Sat, 28 Jun 2008 09:52:59 GMT

Anirban,

both are for diffrent purpose.you can use both while creating a custome table.

just refer this thread answered by me.

and for table index:

Amit.

Re: INDEX OR BUFFER

Former Member — Sat, 28 Jun 2008 17:28:52 GMT

hi ,

Buffering should be used for tables that are being used more frequently, so in that case you can use buffering.But indexing should be used when you dont have the option of using the primary keys for searching into a large table.

Hope this would be sufficent ,

regards

Varghese