INDEX OR BUFFER

[Former Member]

Hi all,

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

Anirban Bhattacharjee

[Former Member]

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.

[Former Member]

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