Re: Is my query using index
From: Odd Morten Sveås <odd.morten.sveas_at_accenture.com>
Date: 30 Sep 2002 09:14:10 -0700
Message-ID: <4306a83.0209300814.7250612f_at_posting.google.com>
Date: 30 Sep 2002 09:14:10 -0700
Message-ID: <4306a83.0209300814.7250612f_at_posting.google.com>
kumar_kmk_at_hotmail.com (Kumar) wrote in message news:<bce41b15.0209291957.520c21b0_at_posting.google.com>...
> If there is a index created on a table, and a query is run against the table
> how do I know if the index is being used or not.
Use explain plan, but first of all:
Search the FAQ's and this groups before posting.
Rgds
Odd M
Received on Mon Sep 30 2002 - 18:14:10 CEST