Home » RDBMS Server » Server Administration » Index
Index [message #372698] Sat, 03 March 2001 11:30 Go to next message
Sunand
Messages: 1
Registered: March 2001
Junior Member
What is index and how can it be used

Report message to a moderator

Re: Index [message #372699 is a reply to message #372698] Sat, 03 March 2001 11:55 Go to previous message
ramu
Messages: 82
Registered: February 2001
Member
Hi,

Index is created for accessing the data very quickly from the database..

For your information refer the books..

One more thing is there that is how can you enable an Index for a table only for a certain time?

We can disable the Index by the giving <> operator on the indexed column..

For example, if you created an index for empno on emptable then you can disable the index by the following query(only for that query)

SELECT *FROM EMP WHERE EMPNO<>10;

Now the index which was created for the column will not work for this query only..

For more details study the guide and materials.

Thanks..

Ramu..

Report message to a moderator

Previous Topic: sql
Next Topic: how to select a image from table?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 13 23:25:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.